Nth Highest salary

Question

How to get Nth highest salary in Sql Server?

Iftikar Hussain · Answer

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

Vulpes · Answer

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