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
- 9307 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 get the ddl of a table in db2?
Is ibm db2 free?
What is db2 purescale?
Define declaration generator (dclgen).
Can you use max on a char column?
How can you do the explain of a dynamic sql statement?
What is lock escalation in db2?
How to restart a DB2 program?
Mention the definition of cobol in varchar field.
List some fields from sqlca?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
How does a cursor work?
What is the use of reorg in db2?
Is db2 free?
Which isolation level provides maximum concurrency?
