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

SELECT de.emp_no as emp_no,dm.emp_no as manager_no,s1.salary as emp_salary,s2.salary as manager_salary
FROM salaries s1
JOIN dept_emp de ON s1.emp_no = de.emp_no
JOIN dept_manager dm ON de.dept_no = dm.dept_no
JOIN salaries s2 ON dm.emp_no = s2.emp_no
WHERE de.to_date = '9999-01-01'
and dm.to_date = '9999-01-01'
and s1.salary > s2.salary

• to_date的限制条件选s1和s2也可以，这个办法用四表相连，更简洁，但是没有高赞好理解，重点在于两次用到salaries表取出员工薪资和经理薪资，借鉴了第二高赞的思路，仅供学习