- 查询第二高的薪水,如果只有一条记录,则返回NULL
select IFNULL(
(select distinct salary from employee order by salary desc LIMIT 1 OFFSET 1),
NULL) as secondHighestSalary;
SELECT
(SELECT DISTINCT salary FROM Employee ORDER BY Salary DESC LIMIT 1 OFFSET 1)
AS secondHighestSalary;
参考: