LeetCode[MySQL] : Second Highest Salary

Second Highest Salary

Q

IFNULL

SELECT IFNULL(
      (SELECT DISTINCT Salary
       FROM Employee
       ORDER BY Salary DESC
       LIMIT 1, 1), NULL) AS SecondHighestSalary
       # OFFSET 1