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.
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 the meaning concurrency in the db2 database?
What db2 400?
How do I change the column size in db2?
How can you classify the locks in db2?
What does db2 plan contain?
What is the difference between cursor stability and repeatable read isolation levels?
What is a db2 tablespace?
What is the picture clause of null indicator variable?
Mention the definition of cobol in varchar field.
What is a buffer in memory?
What is plan in cobol db2?
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?
How to create backup table in db2?
How to check last update on table in db2?
What is blu acceleration in db2?