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

1、关联查出员工工资，经理id，经理工资
2、过滤员工工资比经理高

SELECT
    dept_emp.emp_no,
    dept_manager.emp_no manager,
    salaries.salary,
    d.salary msal
FROM
    dept_emp,
    salaries,
    dept_manager,
    salaries d
WHERE
    dept_emp.emp_no = salaries.emp_no
AND dept_emp.dept_no = dept_manager.dept_no
AND dept_manager.emp_no = d.emp_no
AND salaries.salary > d.salary;