题解 | #获取所有员工当前的manager#
获取所有员工当前的manager
https://www.nowcoder.com/practice/e50d92b8673a440ebdf3a517b5b37d62
select t1.emp_no ,t2.emp_no as manager from( select e.emp_no,d.dept_no from dept_emp e join dept_manager d using(dept_no) )t1 left join ( select dept_no, emp_no from dept_manager )t2 on t1.dept_no = t2.dept_no where t1.emp_no != t2.emp_no


凡岛公司福利 595人发布