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

select
    emp_no,
    salary,
    last_name,
    first_name
from
    employees
    join salaries using (emp_no)
where
    salary in (
        select
            max(salary) as second
        from
            salaries
        where
            salary not in(
                select
                    max(salary) as salary
                from
                    salaries
            )
    )