Question 1
Write an SQL query to find the second highest salary from an employee table.
Solve this coding problem in your preferred language. Review the solution below once you're done.
Solution
Use MAX salary less than the overall MAX salary, or use ranking functions if supported.