Simple Approach ::
SELECT max(salary) FROM emptable WHERE salary < (SELECT max(salary) FROM emptable);
Alternate Approach ::
SELECT sal FROM emp ORDER BY sal DESC LIMIT 1, 1;