Write your MySQL query statement below
MySql取第二高薪水
#(1)
select
Salary as SecondHighestSalary
from Employee
order by
Salary desc
#limit后面可以跟一个或俩个参数:
#(1)只有一个参数时,默认取排序后最上面的一条
#(2)俩个参数时:
#i.第一个参数代表从第几条数据开始取,默认从0开始;
#ii.第二个参数代表取多少条数据。
limit 1,1
– limit 1,-1 代表取从第二条到最后
#(2)首先取最大的一条,那么除去这条后最大的便是第二高的薪水。
select
max(Salary) as SecondHighestSalary
from Employee
where Salary not in
(select
max(Salary) as Salary
from Employee)
#(3)limit X offset Y 从第X条开始,取Y条
select
Salary as SecondHighestSalary
from Employee
order by
Salary desc
limit 1
offset 1