求删除表中重复记录的sql语句！！！

[wallis]

求删除表中重复记录的sql语句！！！

[Yang_]

select distinct * into temptable from tablename
go
truncate table tablename
go
insert tablename
select * from temptable
go
drop table temptable
go

[OpenVMS]

前面太多这样的帖子,可惜网络太慢
假使表中只有name,num2字段
delete a
from #t1 a
where exists(select name,num from #t1 where name=a.name and num=a.num group by name,num having count(*)>1)

[愉快的登山者]

select distinct * into #temptable from tablename
delete tablename
go
insert into tablename from select * from #temptable
go

[愉快的登山者]

select distinct * into #temptable from tablename
delete tablename
go
insert into tablename from select * from #temptable
go