Sai Reddy

Sai Reddy

  • 1.7k
  • 201
  • 9.2k

employee who work in different departments

Jul 19 2018 1:18 AM
 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. 

Answers (7)