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

select e.emp_no,s.salary,e.last_name,e.first_name
from employees e,salaries s,(
    select max(salary) salary
    from salaries
    where salary != (
        select max(salary) salary
        from salaries
    ) # firstMax
) secondMax
where e.emp_no = s.emp_no and s.salary = secondMax.salary

把最大工资排除后，剩下数据的最大工资就是第二工资