Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11601 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
is it compulsory commitment control in journal?
How to find schema of a table in db2?
How to check sequence on a table in db2?
What language is db2 written in?
Explain the function done by data manager?
How to view db2 table structure?
What is the advantage in De-normalizing tables in DB2?
What is explain plan in db2?
What is the difference between plan and package in db2?
How to find the maximum value in a column in the db2 database?
What is release/acquire in bind?
Explain what are the various isolation levels possible?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is a Foreign Key?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
