Click here to Skip to main content
15,882,278 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
Pls some one tell that

how to find 6th highest salary from emp table

Pls some one tell.....
ridoy 7-Sep-13 12:40pm    
we don't see your emp table here!

Hello Chander Rani

You can use the following SQL Select Command for your requirement:-

select top 1 * from (select top 6 empid,empname,salary from employees order by salary desc) as t1 order by salary;

Table Name: employees
Salary Column: salary
Other Columns: empid, empname

Please read my recent article in code project and give your comments and rating.
Chat Application in PHP

with regards,

Share this answer
WITH cte (row,lastname,firstname,salary)
SELECT TOP 6 ROW_NUMBER() OVER (ORDER BY salary DESC), lastname, firstname,salary FROM salarytable ORDER BY salary DESC
SELECT * FROM cte WHERE row=6;
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900