题解 | #获取所有员工当前的manager#
获取所有员工当前的manager
https://www.nowcoder.com/practice/e50d92b8673a440ebdf3a517b5b37d62?tpId=82&tqId=29763&rp=1&ru=/exam/oj&qru=/exam/oj&sourceUrl=%2Fexam%2Foj%3Fpage%3D1%26tab%3DSQL%25E7%25AF%2587%26topicId%3D298&difficulty=undefined&judgeStatus=3&tags=&title=
select
e.emp_no,
m.emp_no as manager
from
dept_emp e
left join dept_manager m on e.dept_no = m.dept_no
where
e.emp_no != m.emp_no and e.to_date = "9999-01-01"
#不相等 <> 或者 !=
