如何删除表中的重复记录?

如何删除表中的重复记录?
---------------------------------------------------------------

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

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus