牛客SQL练习-11-获取所有员工当前的(dept_manager.to_date=‘9999-01-01‘)manager，如果员工是manager的话不显示

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