Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 8 Answers
- 12155 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / anandrao
please try this solution also
select count(*),ACC.NO
FROM ACCOUNT
group by ACC.NO
HAVING COUNT(*) > 1
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
If I have a view which is a join of two or more tables, can this view be updateable?
what are bind concepts in db2 cobol?
How to restart a DB2 program?
What is lock escalation in db2?
Which component is responsible for db2 startup and shutdown?
Mention the location where the output received from explain statement is stored.
What is a db2 cursor?
What is the result of open cursor statement?
Why db2 is called db2?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
B37 abend during spufi?
How do I import a csv file into db2?
What are the uses of db2 optimizer?
What is the physical storage length of date data type?
How to find primary key of a table in db2?
