LeetCode SQL limit & offest 用法
limit & offest
找第二高薪水
select max(Salary) as SecondHighestSalary
from Employee
where Salary < (select max(Salary) from Employee)
-- 最好的方法limit 和offset用法
SELECT
(SELECT DISTINCT
Salary
FROM
Employee
ORDER
原创
2020-10-11 18:21:10 ·
307 阅读 ·
0 评论