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
- 11652 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
How to check last update on table in db2?
Which component is used to execute the sql statements?
What is db2?
Mention some fields that are a part of sqlca.
What is the maximum size of a char data type in db2?
What is clone table?
Explain how can you do the explain of a dynamic sql statement?
How many databases can be created inside an instance in db2 ?
What is db2 bind?
What is the maximum length of sqlca?
How to retrieve rows from a db2 table in embedded sql?
What is blu acceleration in db2?
What do you mean by rollback?
What is ibm db2 connect?
How many types of page locks can be held in db2?
