日期:2014-05-18 浏览次数:20446 次
--sql2000等高手来,我来个一通俗的 select distinct * into #tmp from a delete from a insert into a select * from #tmp drop table #tmp --sql 2005 delete from a from (select row_number() over(partition by groupnum,B order by groupnum,B ) n,* from a) as a where n!=1