题解 | 获取所有员工当前的manager
获取所有员工当前的manager
https://www.nowcoder.com/practice/e50d92b8673a440ebdf3a517b5b37d62
select t1.emp_no as emp_no, t2.emp_no as manager from dept_emp as t1 left join dept_manager as t2 on t1.dept_no = t2.dept_no where t1.emp_no != t2.emp_no;
众安保险公司福利 171人发布
投递字节跳动等公司10个岗位 >