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

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

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