select (select distinct Salary from Employee order by Salary desc limit 1,1) as SecondHighestSalary
注意加distinct,如果不加这个关键字,无法通过测试。
select (select distinct Salary from Employee order by Salary desc limit 1,1) as SecondHighestSalary
注意加distinct,如果不加这个关键字,无法通过测试。