HELPPPPPPP

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

to be honest I'm not entirely sure of how to do this with sql server, but this is the theory:

form a new table based on selecting the distinct rows from the table

something like

create table2 as (
select distinct *
from table1);

I've never used sql server before so i am not sure of the syntax, but something similar must be possible. Sorry I can't give you working code.

It begs the question though, why is there no primary key?