题解 | #获取所有员工当前的manager#
获取所有员工当前的manager
http://www.nowcoder.com/practice/e50d92b8673a440ebdf3a517b5b37d62
代码
select e.emp_no , m.emp_no as manager
from dept_emp as e
join dept_manager as m
on e.dept_no = m.dept_no
where e.emp_no not in
(
select m.emp_no from dept_manager as m
)
思路
- 确认要取的数:员工和员工对应经理的emp_no
- 确认来自表格:dept_emp,dept_manager
- 因为经理的emp_no不显示,所以要用子查询,在dept_manager中将经理的emp_no剔除,所以用where e.emp_no not in ( select m.emp_no from dept_manager as m )