CODE EXAMPLE FOR SQL

Find second highest salary in MySQL?

SELECT salary FROM (SELECT salary FROM emp_table ORDER BY salary DESC LIMIT 2) AS emp ORDER BY salary LIMIT 1;