[Leetcode SQL] Second Highest Salary, leetcodehighest

[Leetcode SQL] Second Highest Salary, leetcodehighest

The original question is as follows:

Write a SQL query to get the second highest salary fromEmployeeTable.

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

For example, given the above Employee table, the second highest salary is200. If there is no second highest salary, then the query shocould returnNull.

The solution is as follows:

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

The idea is to first find the highest salary, and then check the highest salary among the remaining people, which is the second highest ~