I've got a table inside my database.
But, the table creates duplicates itself...

So, for 1 unique record will duplicates to 2 or 3 records.

My question is...
How can I delete the duplicates ??? Coz, when I try to delete, even just 1 records of them, all of the same records will be deleted automatically.

Could anybody help ???

For your information, I'm using SQL Server ver. 7.0

Cheers,
Wen Lie