176. 第二高的薪水

点击查看代码

提示：max函数确保没有返回值时输出为null

SELECT MAX(salary) AS SecondHighestSalary
FROM (
  SELECT 
    DISTINCT salary,
    DENSE_RANK() OVER (ORDER BY salary DESC) AS rnk
  FROM Employee
) AS ranked_salary
WHERE rnk = 2;