Try this one select ACC.NO,ACC.NAME FROM ACCOUNT group by ACC.NO H

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

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

Answer Posted / suleman

Try this one

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

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is db2 relational database?

962

What is commit in db2?

1027

What is the difference between dbm cfg and db cfg file in db2 ?

1518

What is a db2 collection?

1013

What is clone table?

1027

Explain dclgen.

1178

What is precompiler in db2?

992

What is null indicator in cobol db2?

1035

What are bind parameters in db2?

1020

How to find schema of a table in db2?

995

What is dbrm in db2 database?

1089

Are views updateable?

1128

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

2198

Can one database have multiple instances?

1033

What is a plan and package in db2?

1084