LeetCode刷题实战176:第二高的薪水
Write a SQL query to get the second highest salary from the Employee table.
题意

解题
select max(a.salary) as SecondHighestSalary
from Employee a
where a.salary <> (select max(a.salary) from Employee a)
赞 (0)
Write a SQL query to get the second highest salary from the Employee table.
select max(a.salary) as SecondHighestSalary
from Employee a
where a.salary <> (select max(a.salary) from Employee a)