题目描述
Write a SQL query to get the second highest salary from the Employee
table.
1 |
+----+--------+ |
For example, given the above Employee table, the query should return 200
as the second highest salary. If there is no second highest salary, then the query should return null
.
1 |
+---------------------+ |
查找第二大的元素,只需要在where语句中过滤掉最大的元素后再使用max即可
代码实现
1 |
select max(Salary) as SecondHighestSalary from Employee where Salary < (select max(Salary) from Employee) |
近期评论