select distinct * into #table_name from table_name delete from table_name select * into table_name from #table_name drop table #table_name