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;

參考：

• https://leetcode-cn.com/problems/second-highest-salary/solution/di-er-gao-de-xin-shui-by-leetcode/

總結

以上是生活随笔為你收集整理的MySQL语句第二高的薪水查询的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。