plz give me a solution to my doubts..

Dear Friends,

Can any one give me a solution to my doubts?
My doubts are 1. can we add unique constraint to a table which already have duplicate rows. Is it any way that we can add unique constraint to a table which has duplicate rows? ( I don't want to delete duplicate rows from table).

2. I have a table which consist of 20 records.I want to delete 19 records out of 20. Can any one tell how to delete 19 rows from table without using where condition?

Regards

Rajesh

Hi Rajesh,

u cant not add a unique contraint to a column of a table containing duplicate rows as Existing data is checked against the new condition before the statement succeeds.

Regards
Risham