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

select
    e.emp_no,
    s.salary,
    e.last_name,
    e.first_name
from
    employees e
    left join salaries s on e.emp_no = s.emp_no
where
    s.salary = (
        select
            max(salary)
        from
            salaries
        where
            salary < (
                select
                    max(salary)
                from
                    salaries
            )
    )