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
- 9910 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 is universal database?
What is collection in db2 bind?
Is db2 free?
How to rename a table in DB2 ?
What is the maximum size of varchar data type in db2?
What do you mean by between and in? Is between inclusive of specified range values?
Give the name of some fields form sqlca.
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is bind in db2?
What is a trigger in the db2 database?
What is the role of data manager in the db2 database?
How can you find out the # of rows updated after an update statement?
How to check last update on table in db2?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is the advantage in De-normalizing tables in DB2?
