Thanks a lot Mr.Mallikarjun but the inner query u wrote alone does the wor

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.

Question Posted / rihaan

8 Answers
11954 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

Please Help Members By Posting Answers For Below Questions

What is precompiler in db2?

1023

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9216

What is consistency token in db2?

1145

When do you specify the isolation level?

1034

Mention the downsides of page level lock.

1163

What is a Foreign Key?

1100

Why db2 is called db2?

1044

What is declare cursor?

1125

What is the use of dclgen in db2?

1085

What does db2 mean?

1018

Explain about mirror activator disk mirroring?

1013

What are the two types of logging in the db2 database? Explain them.

1078

What is syscat in db2?

1013

What is the difference between drop table and delete table?

1213

What is database alias db2?

1129