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

select
    employees.emp_no,
    salaries.salary,
    employees.last_name,
    employees.first_name
from
    salaries,employees
where
    salary < (
        select
            max(salary)
        from
            salaries
    )
    and salary >= all (
        select
            salary
        from
            salaries
        where
            salary < (
                select
                    max(salary)
                from
                    salaries
            )
    )
    and salaries.emp_no = employees.emp_no