LeetCode题解(0176):查询第二高的薪水(SQL)
程序员文章站
2022-07-07 09:46:46
...
LeetCode题解:0176(第二高的薪水)
题目链接(简单)
解法 | 执行用时 |
---|---|
Ans 1 (SQL) | 157ms (>54.65%) |
解法一:
SELECT max(Salary) as SecondHighestSalary
FROM Employee
WHERE Salary < (SELECT max(Salary) from Employee);