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
- 9911 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / lol
select ACC.NO||ACC.Name from ACCOUNT having count(acc.no||acc.name) >1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain about rct in db2?
What is bind package and plan in db2?
What is coalesce in db2?
What is a db2 package?
What are db2 tables?
what is a corelated subquerry?
What is ibm db2 connect?
Which are the db2 tools to protect integrity of the database?
What is a db2 collection?
How can you classify the locks in db2?
What is the difference between using bind () and rebind () methods of naming class?
What is data manager?
How is the value function used?
What is null in db2?
What is dbrm? When it will be created?
