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


Please Help Members By Posting Answers For Below Questions

What is the meaning concurrency in the db2 database?

877


What db2 400?

928


How do I change the column size in db2?

881


How can you classify the locks in db2?

858


What does db2 plan contain?

779


What is the difference between cursor stability and repeatable read isolation levels?

944


What is a db2 tablespace?

805


What is the picture clause of null indicator variable?

912


Mention the definition of cobol in varchar field.

921


What is a buffer in memory?

817


What is plan in cobol db2?

811


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?

1858


How to create backup table in db2?

869


How to check last update on table in db2?

837


What is blu acceleration in db2?

853