sql排序输出第n个字段 方法汇总

标题 方法一: limit A offset B select distinct Salary as SecondHighestSalary from Employee order by Salary Desc limit 1 offset 1; 由于没有考虑如果没有第二个字段怎么办。 改进: select (select distinct Salary as SecondHighestSalary from Employee order by Salary Desc limit 1 offset 1) as SecondHighestSalary; 这里使用了临时表。 但是我看官方题解