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
11844 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

How is a typical db2 batch pgm executed?

1159

How do I connect my db2 database to ibm?

1030

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1094

What is cascading rollback?

1191

What are the contents of a dclmgen?

1105

How does db2 sample database connect?

1012

What is dclgen (declaration generator)?

1036

Before you give the explain statement, what are the prerogatives?

1014

How do I delete a table in database?

1005

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2218

What is db2 bind process?

1223

How many databases are there?

1036

How does cobol compile db2 program?

1034

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2202

When do you specify the isolation level?

1015