题解 | #薪水第二多的员工，使用max比较#

select
    A.emp_no,
    salary as salary,
    last_name,
    first_name
from
    employees as A
    inner join salaries as B on A.emp_no = B.emp_no
where
    salary = (
        select
            #找到排除最大的salary后最大的salary，即第二大的salary
            max(salary) as salary
        from
            salaries
        where
            salary != (
                # 找到最大的salary
                select
                    max(salary)
                from
                    salaries
            )
    );