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
- 10521 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 node in db2?
What is query_cache_limit?
What is runstats db2?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
How to get the ddl of a table in db2?
What are host variables in db2?
How do I add a column to a table in db2?
How can you quickly find out the # of rows updated after an update statement?
Can one database have multiple instances?
What are the different types of base tables?
What is access path in db2?
What is concurrency?
What is buffer pool in the db2 database?
Is ibm db2 open source?
What is the maximum number of columns in a db2 table?
