题解 | #找出所有员工当前薪水salary情况#

select a.emp_no,c.emp_no as manager_no,b.salary as emp_salary,
(select salary from salaries  
 where emp_no=c.emp_no and to_date='9999-01-01') as manager_salary             --找出部门manager当前薪资
from dept_emp as a 
inner join salaries as b on a.emp_no=b.emp_no
left join dept_manager as c on a.dept_no=c.dept_no
where b.salary > manager_salary 
and b.to_date='9999-01-01'           --与部门manager当前薪资进行比对