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
- 11979 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
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is dclgen (declaration generator)?
How and when does the db2 enforces the unique key?
What is the information associated with sysibm.syslinks table?
What is the use of runstats in db2?
How to check sequence on a table in db2?
What is a system catalog table in db2?
What is sqlca?
What is dbrm in db2 database?
What is the advantage in De-normalizing tables in DB2?
What is clone table?
What is the function of logging in the db2 database?
what is db2 restart?
How can record locking be achieved in those DB2 versions which do not support it?
What is temporal table in db2?
