176. Second Highest Salary

Poison

2023-02-26

SQL

1	SELECT IFNULL((SELECT DISTINCT salary FROM Employee e ORDER BY salary DESC LIMIT 1, 1), NULL) AS 'SecondHighestSalary'

注意 DISINTCT 关键字的使用，即相同的薪水不能算做第二高的薪水。