In a single table,How to retrieve a employee-id of an employee who works in more than one department?
select employee_id from employee table where department in ('a1','a2','b1','b2');