DELETE FROM T WHERE [ID] IN ( select [ID] from T where A in (select A from T Group By A,B,C,D Having count(*)>1) and [ID]<> (select min(ID) as minID from T Group By A,B,C,D Having count(*)>1) )
更正： delete from T where T.ID not in (select min(ID) from T group by T.A,T.B,T.C,T.D)
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 
