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
11705 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 is meant by explain?

1083

Why select is not preferred in embedded sql programs?

1255

Mention the various locks that are available in db2.

989

What is the maximum size of varchar data type in db2?

1084

What are the full forms of spufi and dclgen and why are they used?

1035

How does cobol compile db2 program?

1023

What is rebind in db2?

1017

How to find primary key of a table in db2?

1019

Define buffer pool.

1008

Differentiate between cs and rr isolation levels? Where do you specify them?

1038

What is bind package and plan in db2?

1021

What is db2 and what is the use of db2 optimizer?

1011

What is access path in db2?

943

What is a db2 table?

977

What is lock escalation in db2?

980