In a single table,How to retrieve a employee-id of an employee who works in more than one department?
Select emp_id from employee where dept IN (select DISTINCT dept from employee);
To Refer this Site to Your Friends 
Site Map