Problem

Write a SQL query to find the second highest salary from the employees table.
Example input:
| Id | Salary |
| 1  | 1000   |
| 2  | 2000   |
| 3  | 3000   |
Example output:
| Salary |
| 2000   |

Solution

SELECT MAX(Salary) AS Salary
FROM Employee
WHERE Salary < (SELECT MAX(Salary) FROM Employee)

/*

The solution above is optimal because it uses a subquery to find the maximum salary and then uses that value to find the second highest salary.

*/