select distinct ACC.NO, ACC. NAME, ACC

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

8 Answers
11972 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / mallikarjun

select distinct ACC.NO,
ACC. NAME,
ACC. AMOUNT

from account
where acc.name in
( select distinct acc.name
from account
group by acc.name
where count(acc.no) > 1)

Is This Answer Correct ?

3 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1187

What does db2 plan contain?

1031

Explain the contents that are a part of dclgen.

1093

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

8306

What is role in db2?

1113

How to view db2 table structure?

1022

What is explain in db2?

1036

How do I create a view in db2?

1029

What is a bind card?

1225

Define db2 and its databases?

1059

Name the various locking levels available?

1101

Is db2 a mainframe database?

1006

What is bind and rebind in db2?

1141

Mention data types used in db2 ?

1166

What is the physical storage length of timestamp data type?

1102