In a single table,How to retrieve a employee-id of an employee who works in more than one department?
select employee-id from table-name grtoup by employee-id having count(*) > 1