Second Highest Salary



Write a SQL query to get the second highest salary from the Employee table.

+----+--------+
| Id | Salary |
+----+--------+
| 1  | 100    |
| 2  | 200    |
| 3  | 300    |
+----+--------+

For example, given the above Employee table, the second highest salary is 200. If there is no second highest salary, then the query should return null.

题意：给出一个Employee表，找出工资第二多的数

思路：先查询到最大值，然后再在除去最在大值后求最大值（子查询）

select max(salary) from Employee where salary not in (select max(salary) from Employee)

用时919ms

SELECT MAX(Salary)
FROM Employee
WHERE Salary < (SELECT MAX(Salary) FROM Employee);