题解 | #获取当前薪水第二多的员工的emp_no#

就这么点东西。

select
    e.emp_no ,
    f.salary,
    e.last_name,
    e.first_name
from  employees e join salaries f on e.emp_no = f.emp_no
    join (
            select
                a.salary,
                count(distinct b.salary) as rk
            from salaries a join salaries b on a.salary <= b.salary
            group by a.salary
        ) d on f.salary = d.salary and d.rk = 2