用SQL语句删吧.
如第一个字段名:A ,第二个Bselect * into #Temp from Table group by A,B having count(*)>1delete t1 from Table t1,#Temp t2 where t1.A=t2.A and t1.B=t2.Binsert into Table select * from #Tempdrop table #Temp随手写的,仅供参考
如第一个字段名:A ,第二个Bselect * into #Temp from Table group by A,B having count(*)>1delete t1 from Table t1,#Temp t2 where t1.A=t2.A and t1.B=t2.Binsert into Table select * from #Tempdrop table #Temp随手写的,仅供参考
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货