题目:
方法一:使用子查询和 limit子句
思路:
将不同的薪资按降序排序,然后使用limit子句获得第二高的薪资。
代码:
select
(
select distinct salary
from employee
order by salary desc
limit 1,1
)
as SecondHighestSalary;
题解二:使用 max 函数
思路:
找出小于该字段最大值的最大值,即为第二大值
代码:
select max(Salary) as SecondHighestSalary
from Employee
where Salary < (
select max(Salary) from Employee
);