In a single table,How to retrieve a employee-id of an employee who works in more than one department?
ans 5 need to be corrected... subquery will fetch correct result but main query hw it will compare... ??? it supposed to be where eid exists(select eid...where e1.eid= e2.eid)
along with your userid / name. ThanQ
Site Map