# Write your MySQL query statement below
select (select distinct Employee.Salary from Employee order by Employee.Salary desc limit 1 offset 1) as SecondHighestSalary;

TODO: 

distinct 和 offset的理解运用
posted on 2022-04-15 09:56  黎酒  阅读(22)  评论(0)    收藏  举报