How will you find the 3rd max salary in the employment table?

Correct Answer: SELECT DISTINCT(salary) FROM emp as e1 WHERE (3) = (SELECT COUNT(DISTINCT(salary)) FROM emp as e2 WHERE e1salary <= e2salary)