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
- 10494 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 db2 and what is the use of db2 optimizer?
What is difference between rollback and commit?
What is node in db2?
How can you find out the # of rows updated after an update statement?
Is db2 a mainframe?
Explain about dbrm.
What db2 400?
Mention the definition of cobol in varchar field.
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is a bind in db2?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is check constraint in db2?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What are host variables in db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
