题解 | #获取所有员工当前的manager#
获取所有员工当前的manager
http://www.nowcoder.com/practice/e50d92b8673a440ebdf3a517b5b37d62
获取所有员工当前的manager 写个最通俗易懂的解法吧。
select d1.emp_no,d2.emp_no as manager from dept_emp as d1, dept_manager as d2
where d1.emp_no not in(select emp_no from dept_manager) and d1.dept_no = d2.dept_no