直接查询如果不存在第二高的Salary不会返回值,所以应该用子查询
select (select distinct Salary from Employee order by Salary desc limit 1,1) as SecondHighestSalary
也可以用IFNULL
ifnull(exr1,exr2) 如果exr1是null那么返回exr2否则返回exr1
select ifnull( (select distinct Salary from Employee order by Salary desc limit 1 offset 1), NULL) as SecondHighestSalary
select max(Salary) as SecondHighestSalary from Employee where Salary <> (select max(Salary) from Employee)