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
- 9369 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / ram prajapati
sir,
is it possible to have duplicate values for a uniquely
defined column.........or ... is it possible to define a
unique index on a column which is not having unique value?
plz help me out..
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the uses of db2 optimizer?
What is alias in db2?
Explain dclgen.
Define predicate?
Can you tell me how can you find out the # of rows updated after an update statement?
What is the physical storage length of timestamp data type?
How can you classify the locks 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
How to create backup table in db2?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What is the use of db2 optimizer?
What is package in cobol db2?
Outputs of explain are with matchcols = 0. What does this signify?
What is the difference between db2 and oracle?
What are the two types of logging in the db2 database? Explain them.
