LeetCode 0176 - Second Highest Salary

Reck Zhang

发布于 2021-08-11 14:53:34

2560

发布于 2021-08-11 14:53:34

文章被收录于专栏：Reck Zhang

Second Highest Salary

Desicription

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 query should return 200 as the second highest salary. If there is no second highest salary, then the query should return null.

+---------------------+
| SecondHighestSalary |
+---------------------+
| 200                 |
+---------------------+

Solution

# Write your MySQL query statement below
select MAX(Salary)
as SecondHighestSalary
from Employee
where Salary < (select MAX(Salary) from Employee)

本文参与腾讯云自媒体同步曝光计划，分享自作者个人站点/博客。

原始发表：2018-06-04，如有侵权请联系 cloudcommunity@tencent.com 删除

sql

null

return

table

本文分享自作者个人站点/博客前往查看

如有侵权，请联系 cloudcommunity@tencent.com 删除。

本文参与腾讯云自媒体同步曝光计划，欢迎热爱写作的你一起参与！

登录后参与评论

0 条评论

热度

LeetCode 0176 - Second Highest Salary

LeetCode 0176 - Second Highest Salary

Second Highest Salary

Desicription

Solution

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐