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
12153 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 a page in db2?

1080

Define db2 and its databases?

1115

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1133

What is the purpose of using commit?

1153

What is a storage group (stogroup)?

1287

What does db2 blu stand for?

1220

When reorg is used?

1184

How do I delete a column in db2?

1157

What is a trigger in the db2 database?

1145

What is cursor with hold option in db2?

1138

What is dpf in db2?

1171

What are the contents of a dclmgen?

1177

How to test SQL -911 error while developing COB-DB2 program

7673

What is buffer pool in the db2 database?

1159

What is the difference between cursor and select statement?

1153