Interested to Buy Any Domain ? << Click Here >> for more details...
In a single table,How to retrieve a employee-id of an
employee who works in more than one department?
- 15 Answers
- 24130 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / ab
Select emp_id from employee where dept IN (select DISTINCT
dept from employee);
| Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
What is reorg?
What is the maximum size of varchar data type in db2?
What is buffer pool and list some of them?
How and when does the db2 enforces the unique key?
What does reorg do in db2?
What is innodb buffer pool?
What happens in bind step in a db2 program?
What is the default page size of buffer pools?
What is a db2 package?
What is precompiler in db2?
Explain about rct in db2?
What is release/acquire in bind?
How can you count the number of rows from a table tab?
Mention the downsides of page level lock.
What is iseries database?
