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