In a single table,How to retrieve a employee-id of an employee who works in mo

In a single table,How to retrieve a employee-id of an
employee who works in more than one department?

Question Posted / anagha

Answers were Sorted based on User's Feedback

In a single table,How to retrieve a employee-id of an employee who works in more than one departme..

Answer / venkat

SELECT EMPLOYEE-ID FROM EMPLOYEE GROUP BY EMPLOYEE-ID,DEPARTMENT HAVING COUNT( DEPARTMENT ) > 1;

Is This Answer Correct ?

0 Yes

2 No

In a single table,How to retrieve a employee-id of an employee who works in more than one departme..

Answer / karthik

select dept,empid , count(*)
from table
goup by dept,empid
having count(*) > 1

Is This Answer Correct ?

0 Yes

3 No

In a single table,How to retrieve a employee-id of an employee who works in more than one departme..

Answer / g.kameswara reddy

select employee_id from employee table where department in
('a1','a2','b1','b2');

Is This Answer Correct ?

7 Yes

11 No

In a single table,How to retrieve a employee-id of an employee who works in more than one departme..

Answer / prasenjit_in

Select emp_id from employee where dept IN (select all
dept from employee);

Is This Answer Correct ?

4 Yes

9 No

In a single table,How to retrieve a employee-id of an employee who works in more than one departme..

Select emp_id from employee where dept IN (select DISTINCT
dept from employee);

Is This Answer Correct ?

2 Yes

8 No