Alter Table tableName add Id int identity

Delete from TableName where id in (Select min(id) from TableName group
by FieldName)

Alter table TableName Drop column id

Madhivanan