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 are the various isolation levels possible?

1124

What does db2 stand for?

1033

Mention data types used in db2 ?

1166

What are concurrency issues?

1107

What is meant by union and union all?

1013

What is rebind in db2?

1073

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2222

What is db2 optimizer?

1253

How to check last update on table in db2?

1063

On which levels locks can be applied?

1143

Can we insert update delete in view?

975

How to execute stored procedures?

1135

Define db2 and its databases?

1059

What is a storage group (stogroup)?

1248

Explain the benefits you can get from mainframe connect?

974