For this scenario duplicate records will not exist in the table as the in

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 / s

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

Please Help Members By Posting Answers For Below Questions

What is the maximum size of varchar data type in db2?

1127

What is explain in db2?

1010

What is the max length of sqlca?

1214

What are the benefits of using the db2 database?

1222

How to find the number of rows in a db2 table?

1114

What is performance tuning db2?

1056

Is db2 a mainframe?

1041

How do I add a column to a table in db2?

1100

How to resolve deadlock issue

20093

What is db2 look?

1018

How can you count the number of rows from a table tab?

1086

When do you specify the isolation level?

1026

What is the use of with ur in db2?

1049

On which levels locks can be applied?

1121

What is schema in db2?

1018