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
- 9304 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 the contention situations caused by locks?
What is null in db2?
What is the role of the data page in the db2 database?
Explain about mirror activator disk mirroring?
What is data manager?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
How do I delete a column in db2?
How do I add a column to a table in db2?
How to rename a table in DB2 ?
What is image copy in db2?
Define db2.
What is a db2 cursor?
What is difference between rollback and commit?
How do you stop a db2 database in linux?
What is a db2 collection?
