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
- 11846 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / mallikarjun
select distinct ACC.NO,
ACC. NAME,
ACC. AMOUNT
from account
where acc.name in
( select distinct acc.name
from account
group by acc.name
where count(acc.no) > 1)
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is dbrm in db2 database?
what are bind concepts in db2 cobol?
How to find the number of rows in a db2 table?
What is the use of dclgen in db2?
How do I create a view in db2?
What is the purpose of using commit?
what is the responsibility of the construction superintendent
Explain the benefits you can get from mainframe connect?
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 cursor with hold option in db2?
What is null indicator in db2?
How to test SQL -911 error while developing COB-DB2 program
How to find schema of a table in db2?
What is cursor stability in db2?
what is db2 restart?
