LeetCode 0176 - Second Highest Salary

Second Highest Salary

Desicription

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

代码语言：javascript复制

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

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

代码语言：javascript复制

 --------------------- 
| SecondHighestSalary |
 --------------------- 
| 200                 |
 --------------------- 

Solution

代码语言：javascript复制

# Write your MySQL query statement below
select MAX(Salary)
as SecondHighestSalary
from Employee
where Salary < (select MAX(Salary) from Employee)

sql null return table

0 人点赞