题解 | #获取所有非manager员工当前的薪水情况#
获取所有非manager员工当前的薪水情况
https://www.nowcoder.com/practice/8fe212a6c71b42de9c15c56ce354bebe
select a.dept_no, a.emp_no, a.salary from dept_manager dr right join ( select dp.emp_no, dp.dept_no, s.salary from dept_emp dp left join salaries s on dp.emp_no = s.emp_no ) a on dr.dept_no = a.dept_no where a.emp_no <> dr.emp_no