[Leetcode] [Database] 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.

题目意思: 选出数据中第二high的数据

---

题目思路: 选出的所有比最大的数据少的数据，从中选出最大的数据

select max(Salary) 
    from Employee e 
        where e.Salary<(
            select max(Salary) from Employee);