database :salary

bobfine

于 2015-02-13 15:50:06 发布

阅读量389

点赞数

本文链接：https://blog.youkuaiyun.com/bobofine/article/details/43795045

版权

本文介绍了一种使用SQL查询来获取员工表中第二高的薪资的方法。通过一个具体的例子展示了如何应对没有第二高薪资的情况。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Write a SQL query to get the second highest salary from the Employee table.

+----+--------+
| Id | Salary |
+----+--------+
| 1  | 100    |
| 2  | 200    |
| 3  | 300    |
+----+--------+

For example, given the above Employee table, the second highest salary is 200. If there is no second highest salary, then the query should return null.

select IFNULL( (select e.Salary from Employee e group by e.Salary order by e.Salary desc limit 1, 1), NULL) SecondHighestSalary;