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

What is the difference between spufi and qmf?

1053

What is deadlock in db2?

1016

How many types of page locks can be held in db2?

993

What is access path in db2?

923

What is a page in db2?

980

What is a trigger in the db2 database?

1014

What do you mean by rollback?

932

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1004

What is the use of db2?

1005

What is the difference between cursor stability and repeatable read isolation levels?

1114

Explain about rct.

1024

is it compulsory commitment control in journal?

2415

Are views updateable?

1070

Explain the benefits you can get from mainframe connect?

910

What is a storage group (stogroup)?

1189