Loading

Nth Highest salary

Abhineet Srivastava

13y1.3k

How to get Nth highest salary in Sql Server?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Iftikar Hussain13y ago
Hi,
Try like this

To select 3rd highest salary

SELECT TOP 1 Salary
FROM ( SELECT TOP 3 Salary
FROM Employee e1 GROUP BY e1.Salary
ORDER BY e1.Salary DESC) e2
ORDER BY Salary

To select 5th highest salary

SELECT TOP 1 Salary
FROM ( SELECT TOP 5 Salary
FROM Employee e1 GROUP BY e1.Salary
ORDER BY e1.Salary DESC) e2
ORDER BY Salary

Regards,
Iftikar
0
Vulpes13y ago
Check this link:

http://www.programmerinterview.com/index.php/database-sql/find-nth-highest-salary-sql/
0