CareerCup

  • Questions
  • Forum
  • Resume Tips
  • RSS
  • Sign In

Interview Question


Country: United States
More Questions from This Interview



Comment hidden because of low score. Click to expand.
1
of 1 vote

SELECT TOP N FROM EMPLOYEE ORDER BY SALARY DESC

- PG September 05, 2012 | Flag Reply
Comment hidden because of low score. Click to expand.
0
of 0 votes

I'm not sure how exactly to interpret this problem. Maybe it's what you wrote or maybe it should be TOP N distinct

- Anonymous September 05, 2012 | Flag
Comment hidden because of low score. Click to expand.
0
of 0 vote

SELECT *
  FROM (
       SELECT *
         FROM employee
        ORDER BY salary DESC
       )
 limit 10;

- chandershivdasani September 05, 2012 | Flag Reply
Comment hidden because of low score. Click to expand.
0
of 0 vote

top n means it may be 5 or 6 or etc and dont use in built functions such as TOP or limit and etc

- Surender September 05, 2012 | Flag Reply
Comment hidden because of low score. Click to expand.
0
of 0 votes

TOP is not a built-in function. It's a keyword that's part of the language.

You can avoid using the exact words TOP and LIMIT, but you'll have to use some other keyword or built-in function to impose some sort of ordering. I could use something like RANK() for instance, but that actually is in fact a built-in function.

For questions like this, it goes without saying that you should be super clear on what the allowed set of language constructs is.

- eugene.yarovoi September 06, 2012 | Flag
Comment hidden because of low score. Click to expand.
0
of 0 vote

select max(salary) as "salary" from employee where salary not in (select top n-1(salary) from employee order by salary desc);

- Shaikh Aqueel September 06, 2012 | Flag Reply


Add a Comment
Name:

Writing Code? Surround your code with {{{ and }}} to preserve whitespace.

Books

is a comprehensive book on getting a job at a top tech company, while focuses on dev interviews and does this for PMs.

Learn More

Videos

CareerCup's interview videos give you a real-life look at technical interviews. In these unscripted videos, watch how other candidates handle tough questions and how the interviewer thinks about their performance.

Learn More

Resume Review

Most engineers make critical mistakes on their resumes -- we can fix your resume with our custom resume review service. And, we use fellow engineers as our resume reviewers, so you can be sure that we "get" what you're saying.

Learn More

Mock Interviews

Our Mock Interviews will be conducted "in character" just like a real interview, and can focus on whatever topics you want. All our interviewers have worked for Microsoft, Google or Amazon, you know you'll get a true-to-life experience.

Learn More