SELECT distinct (salary) FROM (
SELECT ROW_NUMBER() OVER ( ORDER BY SALARY DESC) AS rownumber, Salary
FROM emp group by salary )
AS foo
WHERE rownumber = 1,2,3,4,5
Nth Highest Salary in SQL
this code for find Nth Highest salary in sql server.
Loading