In a single table,How to retrieve a employee-id of an
employee who works in more than one department?
- 15 Answers
- 18795 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
How do I start db2 in windows?
Can one database have multiple instances?
What is the information associated with sysibm.syslinks table?
what is diffrence b/w file-aid tool and file-aid utility???
What is reorg and runstats in db2?
What is runstats utility in db2?
How to take backup of table in db2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Explain the contents that are a part of dclgen.
How do we specify index to include or not during bind process.
What is the use of reorg in db2?
Is ibm db2 open source?
What's The Percentage Free Space ?
What is load replace in db2?
What is the role of the data page in the db2 database?
