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
11600 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 the reason behind not using select * in embedded sql programs?

1043

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

7441

How do I import a csv file into db2?

936

What is temporal table in db2?

988

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2338

Discuss about db2 bind?

1048

What is node in db2?

985

How to execute stored procedure in db2 command editor?

984

Explain about open switch business continuity software?

1072

What is the maximum length of sqlca?

1432

Which component is responsible for db2 startup and shutdown?

980

What is db2 stogroup?

1095

What is role in db2?

1040

What is the max length of sqlca?

1157

What is release/acquire in bind?

1057