please try this solution also select count(*),ACC.NO FROM ACCOUNT grou

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

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

Answer Posted / anandrao

please try this solution also

select count(*),ACC.NO
FROM ACCOUNT
group by ACC.NO
HAVING COUNT(*) > 1

Is This Answer Correct ?

0 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain about open switch business continuity software?

1113

What is with ur in db2?

1286

What is isolation level in db2?

983

What do you mean by cursor?

978

What is meant by union and union all?

987

What are host variables in db2?

1028

What are the benefits of using the db2 database?

1210

Which is faster delete or truncate?

1110

Mention the definition of cobol in varchar field.

1227

What is dbrm?

1087

What is blu acceleration in db2?

1048

What is buffer pool?

1078

What is copy pending status in db2?

1104

What is rct?

1210

How do I optimize a query in db2?

1081