Write a SQL query to find the second highest salary from the employees table. The table has columns for id and salary. The query should return the salary column.
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.
Evaluated at: 2022-11-06 01:44:53