SELECT
e.emp_no,
d.emp_no AS manager_no
FROM
dept_emp e
INNER JOIN dept_manager d ON e.dept_no = d.dept_no
WHERE
e.to_date = '9999-01-01'
AND d.to_date = '9999-01-01'
AND e.emp_no <> d.emp_no
牛客SQL练习-11-获取所有员工当前的(dept_manager.to_date=‘9999-01-01‘)manager,如果员工是manager的话不显示
最新推荐文章于 2022-05-03 16:49:16 发布