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

select
e.emp_no   as emp_no
,m1.emp_no as manager_no
,s1.salary as emp_salary
,s2.salary as manager_salary
from dept_emp e left join salaries s1
on e.emp_no=s1.emp_no #全体员工工资列
left join dept_manager m1
on e.dept_no =m1.dept_no  #经理列
left join salaries s2
on m1.emp_no=s2.emp_no #经理工资列
where e.to_date='9999-01-01'
and s1.salary>s2.salary #当前薪水比其manager薪水还高

因为必须要列出经理工资和经理工号，所以必须加上几列，给员工附上更多的信息，就是其对应的经理工号和工资