2022/12/24

LeetCode 176. Second Highest Salary

問題:輸出第二高的薪水 解法:透過LIMIT和OFFSET搭配

SELECT (SELECT DISTINCT salary FROM Employee ORDER BY salary DESC LIMIT 1 OFFSET 1) AS SecondHighestSalary;