How to find 6th highest salary from Employee table?

Posted by Devin

SELECT TOP 1 salary FROM (SELECT DISTINCT TOP 6 salary FROM employee
ORDER BY salary DESC) a ORDER BY salary

Programming Interview Questions | sql query dba all All

Answers and Comments

Saved Stories

Sponsored Categories