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

What is a storage group (stogroup)?

1189

What is explain plan in db2?

944

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1034

Give the name of some fields form sqlca.

1024

Why db2 is called db2?

972

How to run db2 command in windows?

1141

Explain in brief how does db2 determine what lock-size to use?

961

What is a bind card?

1145

What are types of indexes?

1001

How do we specify index to include or not during bind process.

2072

What is db2 connect?

1010

What is check constraint. Explain with example.

1047

What is null indicator in db2?

1054

What is a db2 tablespace?

1002

What is buffer pool and list some of them?

984