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
- 9374 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
How do I add a column to a table in db2?
Give a brief description of db2 isolation levels?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is dclgen in db2?
What is a bind in db2?
What parameters are used to control the free space in DB2?
What is the maximum length of sqlca?
what is db2 restart?
Is db2 free?
How do I add a column in db2?
How do I copy a table in db2?
Can there be more than one cursor open for any program?
What are the various data types available in db2?
How to access db2 tables in mainframe?
How to rename a table in DB2 ?
