Get the second highest salary from employee table in mysql:
SELECT max(salary) as salary FROM employee WHERE salary < (SELECT max(salary) FROM employee)