Forums - C# Corner

Forum guidelines
Sai Reddy

Sai Reddy

  • 1.6k
  • 180
  • 7.8k

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)