leetcode 176

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

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

原文地址:https://www.cnblogs.com/asenyang/p/13362866.html