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,
5In this code we will learn how to find the Nth highest salary in sql server.
In this code we will learn how to find the Nth highest salary in sql server.
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