Delete duplicate rows with no unique columns

[Sanjay Manial]

I have 4 rows which are exactly the same. I want to delete one row but i do not have any unique identifing columns. How should i delete that row ?

[Andrew Wiegand]

Hi,
You can delete only one record with set rowcount.

set rowcount 1
delete from <table>
where <constraint goes here>

hth,
Andrew


------------
Sanjay Manial at 4/3/00 5:52:36 AM

I have 4 rows which are exactly the same. I want to delete one row but i do not have any unique identifing columns. How should i delete that row ?