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
11696 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 are the different types of base tables?

1047

Explain dclgen.

1153

Give a brief description of db2 isolation levels?

1030

what is the role of the cursor in db2?

1018

What is db2 bind process?

1200

Which is faster delete or truncate?

1083

What is dbrm? When it will be created?

983

What is a bind in db2?

1003

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1046

What is drop table?

970

How can you classify the locks in db2?

1045

Is the primary key a clustered index?

1092

How do I add a column to an existing table in db2?

992

What's The Percentage Free Space ?

1174

What is db2 catalog database?

999