SQL server中，要把一列中的重复记录删除，怎么弄？

create proc delete_SameData as
begin tran
select * into temp from (select distinct id,列名 from table)
delete from table where id not in (select id from temp)
delete from temp
drop table temp
commit
go

delete t-name
where (特征)

找出他们不相同点删

create proc delete_SameData as
begin tran
select * into temp from (select * from table1 union select * from table1) as t1
delete from table1
insert into table1 select * from temp
delete from temp
drop table temp
commit
go

declare