Best Answer - Chosen by Asker
Query to find the Nth highest salary:
SELECT DISTINCT (a.sal)
FROM EMP A
WHERE &N = (SELECT COUNT (DISTINCT (b.sal))
FROM EMP B
Replace &N in the above query with 2 if you want to know the second highest salary and so on.