LeetCode·Database
题目版权归LeetCode所有详情参考:https://leetcode.com/problems/second-highest-salary/
题目如下:Second Highest Salary
- 常规
SELECT (SELECT DISTINCT Salary FROM Employee
ORDER BY Salary DESC
LIMIT 1 OFFSET 1) AS SecondHighestSalary
2.保险起见,加“判空”
SELECT
IFNULL(
(SELECT DISTINCT Salary FROM Employee
ORDER BY Salary DESC
LIMIT 1 OFFSET 1
),
NULL) AS SecondHighestSalary
3.比较输出
SELECT MAX(Salary) AS SecondHighestSalary
FROM Employee
WHERE Salary < (SELECT MAX(Salary) FROM Employee)
注:参考:https://blog.csdn.net/xxzhangx/article/details/78169729