select ACC.NO||ACC.Name from ACCOUNT having count(acc.no||acc.name) >1

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

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

Answer Posted / lol

select ACC.NO||ACC.Name from ACCOUNT having count(acc.no||acc.name) >1

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are foreign keys in db2?

1171

How to access db2 tables in mainframe?

1105

How to get the ddl of a table in db2?

1170

Mention the different locking levels that are available in db2.

1188

What is the difference between cursor and select statement?

1153

Give the name of some fields form sqlca.

1145

Define db2 and its databases?

1115

What is table space in db2?

1072

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1218

What is the physical storage length of timestamp data type?

1151

What is collection in db2 bind?

1064

What is the role of the data page in the db2 database?

1085

What is the difference between using bind () and rebind () methods of naming class?

1464

Explain how can you do the explain of a dynamic sql statement?

1180

What's The Percentage Free Space ?

1285