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

select
    a.emp_no,
    b.salary,
    a.last_name,
    a.first_name
from employees a
left join salaries b
on a.emp_no = b.emp_no
    where b.salary =
        (select max(c.salary)
        from
            (select salary
            from salaries
            where salary <
                (select
                max(salary)
                from employees a
                left join salaries b
                on a.emp_no = b.emp_no))c)

不准用orderby 有点麻