sir, is it possible to have duplicate values for a uniquely defined colum

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.

Question Posted / ram prajapati

8 Answers
11602 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

Please Help Members By Posting Answers For Below Questions

What is load replace in db2?

936

What do you mean by storage group (stogroup)?

984

What is db2 bind process?

1179

How to find the number of rows in db2 tables?

996

How would you find out the total number of rows in a db2 table?

989

How do I optimize a query in db2?

1038

What is reorg?

1071

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1004

What does db2 stand for?

959

Is db2 a programming language?

983

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1049

What is db2 command?

963

What is database reorganization?

1053

What is the maximum size of a char data type in db2?

964

Explain about rct in db2?

1044