How to find the Nth highest salary from a table in SQL?

SELECT DISTINCT  (a.salary)
FROM Employees A
WHERE &N = (SELECT COUNT (DISTINCT (b.salary))
            FROM Employees  B
            WHERE a.salary<=b.salary)

Read More