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

Mention the downsides of page level lock.

1168

What is db2 command?

1045

What is a dbrm in db2?

1033

What is the role of union all and union

1132

what is the sqlcode -501

13173

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1114

What does runstats do in db2?

1129

What is the maximum No of rows per page?

1076

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2224

Can there be more than one cursor open for any program?

1178

What is a db2 cursor?

1065

Is db2 a mainframe database?

1009

Mention the definition of cobol in varchar field.

1253

Explain db2.

1044

What is buffer pool in the db2 database?

1114