如题,请高手指教!

select distinct * into # from tb
truncate table tb
insert into tb select * from #
drop table #