if suppose i am having an ACCOUNT table with 3 coloumns ACC.
NO,ACC. NAME,ACC. AMOUNT . If a unique index is also
defined on ACC.NO and ACC.NAME then write a query to
retrieve account holders records who have more than 1 ACC.
- 8 Answers
- 9331 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / rihaan
Thanks a lot Mr.Mallikarjun but the inner query u wrote
alone does the work.
kindly check it up
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Explain about cursor stability?
What type of database is db2?
What is image copy in db2?
What is null value in db2?
Can we delete records from view?
What are the contents of a dclmgen?
What is blu acceleration in db2?
What is bind and rebind in db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
Explain in detail about buffer manager and its functionalities?
Where do you specify them?
What is database reorganization?
What is the default page size of buffer pools?
What is the use of value function?
What does a deadlock mean in DB2?
