CODE EXAMPLE FOR SQL

query to find second highest salary

SELECT MAX(SALARY) FROM Employee WHERE SALARY < (SELECT MAX(SALARY) FROM Employee)