7
Answers

employee who work in different departments

Sai Reddy

Sai Reddy

6y
699
1
 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)