Get the Second Highest Salary in MySQL
The problem
Write a SQL query to get the second highest salary from the Employee
table.
For example, given the above Employee table, the query should return 200
as the second highest salary. If there is no second highest salary, then the query should return null
.
The solution
SELECT DISTINCT
Salary AS SecondHighestSalary
FROM
Employee
ORDER BY Salary DESC
LIMIT 1 OFFSET 1
The output
{"headers": ["SecondHighestSalary"], "values": [[200]]}