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
Change 3 to n as per your need -
SELECT emp_id, MIN(salary) from ( SELECT emp_id, salary from Employee ORDER BY salary DESC LIMIT 3 );