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
11948 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

Explain db2.

1034

What is the use of dclgen in db2?

1085

What is db2 command?

1036

What is sqlca?

1074

What is db2 stogroup?

1160

What is the maximum length of sqlca?

1529

What are host variables in db2?

1072

Where can you declare a cursor in a cobol-db2 program?

1077

What is difference between isnull and coalesce?

1054

What is the role of data manager in the db2 database?

1107

What is the use of db2?

1055

Explain about mirror activator disk mirroring?

1009

Name the lockable units in DB2?

1128

What is phantom read in db2?

1157

How do I import data from excel to db2?

1072