select (select distinct Salary from Employee order by Salary desc limit 1,1) as SecondHighestSalary

注意加distinct,如果不加这个关键字,无法通过测试。

posted on 2020-07-22 20:10  Sempron2800+  阅读(104)  评论(0)    收藏  举报