How to get 6th heghest salary?

chennaprashanth · #1 (**permalink**) 03-18-2008

In SQL Server 2005, How to get 6th highest salary from a table?

Regards,
Prashanth Chenna.

vikasvaidya · #2 (**permalink**) 03-19-2008

There are already few posts for ur question. You can get your reply from here
http://http://www.geekinterview.com/...st-salary.html

---V V---
Vikas Vaidya

nageshkota · #3 (**permalink**) 08-11-2008

You can use the Query as fallowed

SELECT * FROM <TABLENAME> T1 WHERE n=
(SELECT COUNT(DISTINCT <COLUMNNAME>) FROM <TABLENAME> T2 WHERE T1.<COLUMNNAME> <=T1.<COLUMNNAME>)

where 'n' is the nth highest value for the <COLUMNNAME> in the <TABLENAME>.

jrameshvjr · #4 (**permalink**) 08-27-2008

select top 1 salary
from (select distinct top 6 salary from employee order by salary desc) a
order by salary

nageshkota · #5 (**permalink**) 08-29-2008

Hi jrameshvjr,

your query will give the only one record, if there are many number of employees holding the same salary then it won't be applicable..

Amitaqa · #6 (**permalink**) 09-09-2008

select * from <tablename>emp where salary not in (select distinct top n-1 salary from <tablename>emp order by salary desc)

n=number of highest salary

Priyanka Sinha · #7 (**permalink**) 3 Weeks Ago

select top 1 emp_salary from (select top 6 emp_salary from tblemployee order by emp_salary desc) a order by emp_salary asc

manasachowdary · #8 (**permalink**) 1 Week Ago

select top(6) from tablename,but this will not applicable where there more number of employees drawing the same salary? it includes duplicate rows

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
nth highest salary	veluru13	Oracle	6	02-12-2008 10:47 AM
Structure of Salary	nehalshah	Companies	2	12-07-2007 07:10 AM
employee name and salary from employee and salary table	Himu	SQL	1	07-04-2007 05:34 AM
What is the value for MAX(SALARY)	Geek_Guest	SQL	3	04-04-2007 04:01 AM
Assessing Salary	admin	Career Advice	1	09-27-2006 05:23 AM

The Following 2 Users Say Thank You to chennaprashanth For This Useful Post:
ashwinikate, jrameshvjr

The Following User Says Thank You to jrameshvjr For This Useful Post:
hemant_bh_99

The Following User Says Thank You to Priyanka Sinha For This Useful Post:
Abhijeet.kumar

How to get 6th heghest salary?

How to get 6th heghest salary?

Similar Threads