题解 | #获取所有非manager员工当前的薪水情况#

  select b1.emp_no,manager_no,emp_salary,manager_salary
  from(
    select dept_no,de.emp_no,salary emp_salary
    from dept_emp de
      join salaries s
          on de.emp_no=s.emp_no 
          and s.to_date='9999-01-01'-- 筛选是否在职
  ) as b1 -- 员工工资表
join  -- 连接两个表
    (select dept_no,dm.emp_no as manager_no,salary manager_salary
    from dept_manager dm
        join salaries s
            on dm.emp_no=s.emp_no 
            and s.to_date='9999-01-01'-- 筛选是否在职
) as b2 -- 领导工资表
on b1.dept_no =b2.dept_no -- b1和b2连接条件
where b1.emp_salary > b2.manager_salary;-- 筛选条件