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
11686 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 in brief how does db2 determine what lock-size to use?

987

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2197

B37 abend during spufi?

1418

List down the types of triggers in the db2 database?

977

What are iseries servers?

1027

How to create backup table in db2?

1056

Comment whether the cursor is closed during commit or not.

1057

What is cobol db2?

948

What os does db2 run on?

940

Is ibm db2 free?

964

How do I add a column in db2?

1011

What are the full forms of spufi and dclgen and why are they used?

1035

When reorg is used?

1083

What is db2 bind?

1027

What is a trigger in the db2 database?

1032