求第二高的薪水
现有一张数据库表Employee,有两个字段id 、salary 查询薪资第二高的薪水
解法一:
先查出最高的薪资,再查出小于最高薪资的所有薪资中最高的薪资,查处的、这个薪资就是第二高的薪资。
SELECT MAX(salary) as second_highest_salary
FROM Employee
WHERE salary < (SELECT MAX(salary) FROM Employee);
解法二
对查询结果进行去重排序,然后分页查询查第二个
select
distinct(salary) as SecondHighestSalary
from Employee order by salary desc limit 1,1