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

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