题解 | #获取员工当前薪水比其manager还高#

select
    de.emp_no as emp_no,
    dm.emp_no as manager_no,
    s1.salary as emp_salary,
    s2.salary as manager_salary
from
    dept_emp as de
    join dept_manager as dm on de.dept_no = dm.dept_no
    join salaries as s1 on de.emp_no = s1.emp_no
    join salaries as s2 on dm.emp_no = s2.emp_no
where s1.salary > s2.salary;