Oracle SQL: How to Get 2nd Highest Salary 🔥
SQL Query to Get 2nd Highest Salary:
SELECT SAL FROM
(SELECT ROWNUM RN,E.* FROM
(SELECT DISTINCT SAL
FROM EMP
ORDER BY SAL DESC
) E
)
WHERE RN = 2
SQL Query to Get 2nd Highest Salary:
SELECT SAL FROM
(SELECT ROWNUM RN,E.* FROM
(SELECT DISTINCT SAL
FROM EMP
ORDER BY SAL DESC
) E
)
WHERE RN = 2