需求:查询与141号或174号员工的manager_id和department_id相同的其他员工的employee_id,manager_id,deplartment_id
实现sql:
select employee_id,manager_id,department_id
from employee
where (manager_id,department_id) in (
select manager_id,department_id
from employees
where employee_id in (141,174)
)
and employee_id not in (141,174);