sql语句删除重复行

sql server删除重复行

select distinct * into #temp from cat
delete from cat
insert into cat select * from #temp
drop table #temp