select
(select distinct salary from Employee
order by salary desc limit 1 offset 1)
as SecondHighestSalary
desc降序排列 asc升序
limit1 第一条数据
offset跳过第一条从第二条数据开始
select
(select distinct salary from Employee
order by salary desc limit 1 offset 1)
as SecondHighestSalary
desc降序排列 asc升序
limit1 第一条数据
offset跳过第一条从第二条数据开始