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
- 9372 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / suleman
Try this one
select ACC.NO,ACC.NAME
FROM ACCOUNT
group by ACC.NO
HAVING COUNT(*) > 1
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How to retrieve rows from a db2 table in embedded sql?
What is commit in db2?
Highlight all the advantages that are attached to a package.
How do I delete a table in db2?
What is the difference between plan and package in db2?
What is the purpose of using commit?
What is db2 catalog database?
What does sqlcabc has?
What is a dbrm in db2?
How to create backup table in db2?
What is the result of open cursor statement?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is the difference between spufi and qmf?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is an instance in db2?
