MySQL語句第二高的薪水查詢

程式媛一枚~發表於2020-10-25
MySql
  1. 查詢第二高的薪水，如果只有一條記錄，則返回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;

參考：

相關文章