select A.empid from EMP A, EMP B where A.empid = B.empid and A.dept not =

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

Question Posted / sri

Answer Posted / sri

select A.empid from EMP A, EMP B where
A.empid = B.empid and
A.dept not = B.dept

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is buffer pool in the db2 database?

1159

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3207

What is commit in db2?

1109

Mention some fields that are a part of sqlca.

1099

What is db2?

1237

Mention the definition of cobol in varchar field.

1316

How to get the ddl of a table in db2?

1170

What is an instance database?

1098

What is the difference between drop table and delete table?

1290

How does cobol compile db2 program?

1130

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1134

What is the maximum No of rows per page?

1117

What is dclgen (declaration generator)?

1119

What are host variables in db2?

1125

What is cursor with hold option in db2?

1138