题解 | #获取员工其当前的薪水比其

select
    table1.emp_no,
    table2.manager_no,
    table1.emp_salary,
    table2.manager_salary
from
    (
        select
            s.emp_no,
            de.dept_no,
            s.salary emp_salary
        from
            salaries s,
            dept_emp de
        where
            s.emp_no = de.emp_no
            and de.to_date = '9999-01-01'
    ) as table1
    inner join (
        select
            dm.emp_no as manager_no,
            dm.dept_no,
            s.salary as manager_salary
        from
            salaries s,
            dept_manager dm
        where
            s.emp_no = dm.emp_no
            and dm.to_date = '9999-01-01'
    ) table2 on table1.dept_no = table2.dept_no
    and table1.emp_no != table2.manager_no #从员工薪水表里排除经理薪水数据，（经理也是员工）
where
    table1.emp_salary > table2.manager_salary