In a single table,How to retrieve a employee-id of an
employee who works in more than one department?
- 15 Answers
- 18850 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / venkat
select emp-id from emp group by emp-id having count(*)>1;
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is innodb buffer pool?
What is the role of schema in the db2 database?
How to find the maximum value in a column in the db2 database?
What is the purpose of using commit?
What is the difference between bind and rebind in db2?
What is a bind card?
Define sqlca.
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
Mention the downsides of page level lock.
Explain how can you do the explain of a dynamic sql statement?
What is the maximum length of sqlca?
On which levels locks can be applied?
How can deadlocks be resolved?
What is sqlca?
What are packages in db2?
