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
- 11827 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / rihaan
Thanks a lot Mr.Mallikarjun but the inner query u wrote
alone does the work.
kindly check it up
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is the difference between dbm cfg and db cfg file in db2 ?
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
When the like statement is used?
Explain correlated sub-queries.
What is null value in db2?
Name the various locking levels available?
What is table space in db2?
Where do you specify them?
Can one database have multiple instances?
Mention the different locking levels that are available in db2.
What is a page in db2?
What r the comman abends in db2, jcl and cobol???????
Explain the benefits you can get from mainframe connect?
Explain the contents that are a part of dclgen.
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
