SQL query to find 2nd highest salary.

• Use ORDER BY to sort the salaries in descending order

• Use LIMIT to get the second highest salary

• Use subquery to avoid duplicates if multiple employees have the same...read more

SELECT salary FROM employees e

WHERE n = (SELECT COUNT(DISTINCT salary) FROM employees p WHERE e.salary<=p.salary);

For Second highest salary n=2 in the above query.