employee who work in different departments

Question

 Hi,

I need a query to find an employeeid who work in different departments and vomit single eid

 

deptid    eid

101 1

212 1

314 1

100 2

412 3

506 3

618 3

expected output as follows

 

deptid eid

101 1

212 1

314 1

412 3

506 3

618 3

 

 

Thanks in advance.