SQL Part 2

Question 1

find the second highest distinct salary from Employee(ID, Salary). If there is no second highest salary, return NULL

Answer 1

SELECT (SELECT DISTINCT salary FROM employee ORDER BY salary DESC LIMIT 1 OFFSET 1) AS SecondHighestSalary