Select emp_id from employee group by emp_id,dept having count(*)>1;

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

Question Posted / varun

Answer Posted / varun

Select emp_id
from
employee
group by emp_id,dept
having count(*)>1;

Is This Answer Correct ?

26 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is sqlca’s maximum length?

1250

What do you mean by cursor?

1036

Discuss about db2 bind?

1158

How do I add a column to a table in db2?

1161

What is difference between alias and synonym in db2?

1200

Explain db2.

1088

How can the duplicate values be eliminated from db2 select?

1161

What is the difference between using bind () and rebind () methods of naming class?

1464

What is db2? Explain.

1113

What is dbrm? What it contains?

1217

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2912

Which are the db2 tools to protect integrity of the database?

1169

Why do we bind in db2?

1276

What is ibm db2 database?

1069

Is db2 a mainframe database?

1052