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

WITH temp AS(    
    SELECT c.emp_no,c.manager_no,d.salary emp_salary,e.salary manager_salary
    FROM(   
        SELECT a.emp_no,b.emp_no manager_no
        FROM dept_emp AS a
        JOIN dept_manager AS b ON a.dept_no = b.dept_no
        WHERE a.emp_no != b.emp_no
    ) AS c
    INNER JOIN salaries AS d ON c.emp_no = d.emp_no
    INNER JOIN salaries AS e ON c.manager_no = e.emp_no
)

SELECT * FROM temp
WHERE emp_salary > manager_salary

好多题解啊随便看看吧