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
12152 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 rebind in db2?

1119

What does db2 stand for?

1093

What is the connection string to connect to the DB2 Database ?

1176

what is utility for parm lib

2423

Is db2 a mainframe?

1097

Explain about dbrm.

1110

What is table space in db2?

1072

How to test SQL -911 error while developing COB-DB2 program

7673

Is the primary key a clustered index?

1206

What types of tables are there in the db2 database?

1102

What is the difference between nvl and coalesce?

1110

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

1147

What is clone table?

1114

Mention the various locks that are available in db2.

1089

What does db2 mean?

1086