题解 | 获取所有员工当前的manager
获取所有员工当前的manager
https://www.nowcoder.com/practice/e50d92b8673a440ebdf3a517b5b37d62
select e.emp_no,d.emp_no as manager from dept_emp as e inner join (select e2.emp_no,d2.dept_no from dept_emp as e2 inner join dept_manager as d2 on e2.emp_no = d2.emp_no) as d on e.dept_no = d.dept_no and e.emp_no != d.emp_no
- 先将 manager 的 emp_no 和 dept_no 查出来
- 再与员工表进行关联，排除掉非员工即可
查看32道真题和解析
