题解 | 获取员工其当前的薪水比其manager当前薪水还高的相关信息

# 获取员工其当前的薪水比其manager当前薪水还高的相关信息

select 
t1.emp_no,
t1.manager_no,
s.salary emp_salary,
s1.salary manager_salary
from (
    # 员工和上司
    select
    de.emp_no,
    dm.emp_no manager_no
    from dept_emp de
    left join dept_manager dm
    on de.dept_no = dm.dept_no
    where dm.emp_no != de.emp_no
)t1
left join salaries s
on t1.emp_no = s.emp_no
left join salaries s1
on t1.manager_no = s1.emp_no
where s.salary > s1.salary;