sql语句删除重复行

sql server删除重复行

select distinct * into #temp from catdelete from catinsert into cat select * from #tempdrop table #temp