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

Before you give the explain statement, what are the prerogatives?

970

What is reorg?

1072

can all users have the privilage to use the sql statement select * (dml)?

1106

How do I copy a table in db2?

953

Is schema the same as database?

1008

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1230

What is buffer pool?

1033

Define data page.

1015

What is access path in db2?

926

what is a corelated subquerry?

1065

Explain how can you do the explain of a dynamic sql statement?

1066

What is alias in db2?

983

What is null in db2?

950

How to execute stored procedure in db2 command editor?

986

What is dpf in db2?

1050