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
- 11588 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
Highlight all the advantages that are attached to a package.
What are union and union all?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
List out the three types of page locks that can be held.
What is the use of with ur in db2?
What is host variable in db2 cobol?
What is the advantage in De-normalizing tables 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
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is bind in db2?
How do I add a column to an existing table in db2?
What is a collection in db2?
Define predicate?
What is explain in db2?
What is dclgen (declaration generator)?
