select (select distinct salary
from Employee
order by salary desc
limit 1, 1) as SecondHighestSalary
如果直接查的话,会返回空l而不是null
select ifnull(子查询, null) 如果子查询为null, 返回null,否则返回子查询
select (select distinct salary
from Employee
order by salary desc
limit 1, 1) as SecondHighestSalary
如果直接查的话,会返回空l而不是null
select ifnull(子查询, null) 如果子查询为null, 返回null,否则返回子查询