CareerCup

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

SQL queries


Forum Post 5 Answers SQL queries

Suppose in my database employee table there are 10,000 records , if want want to find out 2549th highest salary then how to do it

 - Shankar Modi June 25, 2014 | Flag |


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

select Salary from Employee
Order By
Salary DESC Limit 2548,1

Note:
Employee - Table Name
Salary - Column
DESC - in Descending order
2548,1 - represents 2549th element

I hope this should work.

- Abhijeet June 25, 2014 | Flag Reply
Comment hidden because of low score. Click to expand.
0
of 0 votes

Thanks Abhijeet , but how to fetch in oracle database ? there is no limit clause

- Shankar Modi June 26, 2014 | Flag
Comment hidden because of low score. Click to expand.
0
of 0 vote

Select * from (Select salary,ROW_NUMBER () OVER (ORDER BY salary) RANK from Employee) where rank =2549

hope this works..!

- Sai June 26, 2014 | Flag Reply
Comment hidden because of low score. Click to expand.
0
of 0 vote

select * from emp a where 2549 = (select count(distinct salary)) from emp b
where a.salary <=b.salary

- snigda.2000 June 26, 2014 | Flag Reply
Comment hidden because of low score. Click to expand.
0
of 0 vote

Select top 25.49 percent salary,employeename
from Employee
Order by salary desc

- Waleed January 02, 2015 | 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