How to Find nth MIN and nth Max Salary

SQL to Find the 3rd MAX salary

SELECT DISTINCT sal
FROM emp e1
WHERE 3 =
(SELECT count(DISTINCT sal)
FROM emp e2
WHERE e1.sal <= e2.sal);

SQL to Find the 3rd MIN salary

SELECT DISTINCT sal
FROM emp e1
WHERE 3 =
(SELECT count(DISTINCT sal)
FROM emp e2
WHERE e1.sal >= e2.sal);

Click here for more Complex SQL Queries.

Related