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
11997 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 db2? Explain.

1058

What is a Foreign Key?

1105

Which component is used to execute the sql statements?

1110

what are bind concepts in db2 cobol?

1108

Why do we need reorg in db2?

1001

What is the difference between using bind () and rebind () methods of naming class?

1413

What is the role of schema in the db2 database?

1286

can we view the access paths created by dbrm ? how ? thx

7116

What is coalesce in db2?

1143

What is innodb buffer pool?

1069

Is db2 a mainframe?

1053

How do you find the maximum value in a column in db2?

1114

How do I change the column size in db2?

1169

What is load utility in db2?

1193

List out the buffer pools in db2

1081