删除重复数据 SQL

删除重复数据

select distinct *
into #temptable
from [yourtable]

delete from  [yourtable]
insert  [yourtable] select * from #temptable
drop table #temptable