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
- 11996 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / ratheesh nellikkal
Hi All,
Here u already have a unique index defined on ACC.NO and ACC.NAME feilds.
Unique index will not allow more than one value for this particular field (Correct me if I am wrong).
Then hw can we get more that one a/c no for a person in this scenario ?
So the answer will be, u can not store more than one a/c number for a person since u have a unique indexes on these table.
Regards,
Ratheesh Nellikal
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How do I import data from excel to db2?
What is copy pending and check pending in db2?
List down the data types in the db2 database.
What is the use of runstats in db2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is declare cursor?
Which are the db2 tools to protect integrity of the database?
Explain correlated sub-queries.
What is the information associated with sysibm.syslinks table?
What does reorg do in db2?
What is bufferpool in db2?
What are the 2 sqlcodes that are returned?
What is plan in cobol db2?
What parameters are used to control the free space in DB2?
can all users have the privilage to use the sql statement select * (dml)?
