Deleting Duplicate Records

[shaileshadate]

Hello,
I am having a Table ABC with one Field Named FieldID,
There are many duplicate record in that Filed.
I want to Delete some of them.
for. eg. Value 3 is repeating 7 times
I want to Delete 2 Row of them.
If I am deleting manually it is giving error.
How can I delete.

Pls help me.
Thaks in advance

[mendhak]

How do you know which row is to be deleted? You're probably getting an error because of the ambiguity that's present due to the duplicate records.

I'd suggest you perform a DISTINCT query on the table into another table, then recreate the original table with the values you retrieved.

Watch your step though.