题解 | 获取当前薪水第二多的员工以及其对应的薪水

select l.*
from (select em.emp_no emn,sa.salary sal,em.last_name lsn,em.first_name fsn
from employees em
inner join salaries sa
on em.emp_no =sa.emp_no) as l
where l.sal=(
select max(l.sal)
from (select em.emp_no emn,sa.salary sal,em.last_name lsn,em.first_name fsn,sa.to_date td
from employees em
inner join salaries sa
on em.emp_no =sa.emp_no) as l
where l.sal<(
select max(l.sal)
from (select em.emp_no emn,sa.salary sal,em.last_name lsn,em.first_name fsn,sa.to_date td
from employees em
inner join salaries sa
on em.emp_no =sa.emp_no) as l
group by l.td
)
group by l.td
)

第一次查询最大薪水

第二次查询小于最大薪水的薪水

第三次查询小于最大薪水的最大薪水