题目地址:
https://leetcode.com/problems/second-highest-salary/
给定一个Employee表如下:
+----+--------+
| Id | Salary |
+----+--------+
| 1 | 100 |
| 2 | 200 |
| 3 | 300 |
+----+--------+
要求返回第二高的Salary,例如,要返回:
+---------------------+
| SecondHighestSalary |
+---------------------+
| 200 |
+---------------------+
可以先找到最高的salary,然后再找比最高salary小的那个最高salar。代码如下:
SELECT MAX(salary) AS SecondHighestSalary
FROM Employee
WHERE salary <
(SELECT MAX(salary) FROM Employee);