SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal);

Enter value for n: 2

3700

How we can get nth max salary from Employee Table (EMP_ID, Salary)

Emp_id salary 1 1000 3 2000 4 16000 2 10000 7 19000 8 12000

e.g. for 3rd max salary, salary is 12000 so answer will be emp_id : 8