题解 | #获取员工其当前的薪水超过其manager的信息#

select s1.emp_no,d.emp_no manager_no,s1.salary emp_salary,s2.salary manager_salary
from salaries s1 join dept_emp de on s1.emp_no=de.emp_no
join dept_manager d on de.dept_no=d.dept_no
join salaries s2 on d.emp_no=s2.emp_no
where s1.emp_no!=s2.emp_no and s1.salary>s2.salary

1、三表连接后，将salries表和dept_manager相连，连接字段emp_no,用来查经理的薪水

2、三表连接的查询条件s1.emp_no!=s2.emp_no and s1.salary>s2.salary