解题思路
先把第二高的薪水查出来 如果有的话 就选择 并且取名为SecondHighestSalary 如果没有第二高的 就把null取名为SecondHighestSalary
代码
select (select distinct Salary from Employee order by Salary desc
limit 1,1) as SecondHighestSalary
解题思路
先把第二高的薪水查出来 如果有的话 就选择 并且取名为SecondHighestSalary 如果没有第二高的 就把null取名为SecondHighestSalary
代码
select (select distinct Salary from Employee order by Salary desc
limit 1,1) as SecondHighestSalary