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
- 11921 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 action db2 takes when a program aborts in the middle of a transaction?
What is the role of data manager in the db2 database?
What is query_cache_limit?
What is cursor stability in db2?
Can there be more than one cursor open for any program?
Mention some fields that are a part of sqlca.
what is utility for parm lib
What type of database is db2?
How is the value function used?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Is ibm db2 open source?
What is blu acceleration in db2?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is coalesce in db2?
What is the use of commit in db2?
