【leetcode SQL】Second Highest Salary，leetcodehighest

【leetcode SQL】Second Highest Salary，leetcodehighest

原題如下：

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.

解決方案如下：

# Write your MySQL query statement belowselect max(Salary)from Employee where Salary<(select max(Salary) from Employee )

思路是先查出工資最高的，然後再查剩下的人裡面工資最高的，就是第二高的了~