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
11721 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

How to check last update on table in db2?

1022

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1161

What is ibm db2 connect?

957

How can you classify the locks in db2?

1058

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1359

What is null in db2?

973

How to retrieve rows from a db2 table in embedded sql?

1360

What is nvl in db2?

1068

What are db2 objects?

1020

Is it possible using max on a char column?

1105

What is scrollable cursor in db2?

1022

What is a db2 cursor?

1026

What is check constraint in db2?

1032

What is with ur in db2?

1270

Explain about open switch business continuity software?

1097