本文共 352 字，大约阅读时间需要 1 分钟。

题目描述：

方法一：

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

方法二：

select max(Salary) as SecondHighestSalary from(select Salary from Employee where Salary!=(select max(Salary) from Employee)) tmp;

修订版：

select max(Salary) SecondHighestSalaryfrom Employeewhere Salary!=(select max(Salary) from Employee);

转载地址：https://liuxingchang.blog.csdn.net/article/details/111703265 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！