176. 第二高的薪水

点击查看代码

提示：max函数确保没有返回值时输出为nullSELECT MAX(salary) AS SecondHighestSalary
FROM (SELECT DISTINCT salary,DENSE_RANK() OVER (ORDER BY salary DESC) AS rnkFROM Employee
) AS ranked_salary
WHERE rnk = 2;