题解 | #获取所有员工当前的manager#
获取所有员工当前的manager
https://www.nowcoder.com/practice/e50d92b8673a440ebdf3a517b5b37d62
select
a.emp_no,
b.emp_no as manager
from
dept_emp as a
inner join
dept_manager as b
on
a.dept_no = b.dept_no
and
a.emp_no != b.emp_no;
投递滴滴等公司10个岗位
学而思开奖124人在聊