题目:获取所有员工当前的manager,如果当前的manager是自己的话结果不显示,当前表示to_date=‘9999-01-01’
SELECT de.emp_no,dm.emp_no as manager_no
from dept_emp as de inner join dept_manager as dm
on de.dept_no =dm.dept_no
WHERE de.emp_no!=dm.emp_no
题目:获取所有员工当前的manager,如果当前的manager是自己的话结果不显示,当前表示to_date=‘9999-01-01’
SELECT de.emp_no,dm.emp_no as manager_no
from dept_emp as de inner join dept_manager as dm
on de.dept_no =dm.dept_no
WHERE de.emp_no!=dm.emp_no