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
- 9368 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / s
For this scenario duplicate records will not exist in the
table as the index has been defined on the 2 primary keys.
Hence the answer is we can't pull the account holders
having more than 1 account
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is dpf in db2?
What is the use of runstats in db2?
what is diffrence b/w file-aid tool and file-aid utility???
What is the maximum size of a char data type in db2?
What are the bind parameters ibm db2?
What is data manager?
What is the purpose of rollback and commit?
What type of database is db2?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is the maximum No of rows per page?
How can record locking be achieved in those DB2 versions which do not support it?
What is the difference between nvl and coalesce?
How to test SQL -911 error while developing COB-DB2 program
What's The Error Code For Unique Index Voilation?
What is sqlca?
