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
- 9371 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
What is explain plan in db2?
How to retrieve rows from a db2 table in embedded sql?
What is dbrm?
Who uses db2?
What is sqlca’s maximum length?
What is syscat in db2?
What is multi row fetch in db2?
What is the physical storage length of the data types date, time, and timestamp?
How to fetch the last row from the table in SQL (db2)?
What is page size in db2?
What is a buffer in memory?
What does reorg do in db2?
What is drop table?
What is db2 bind?
How connect db2 database to datastage?
