直接上SQL语句：
DELETE FROM TJ_TB_Order FROM dbo.TJ_TB_Order O
INNER JOIN (SELECT * FROM (
SELECT OriginID,OriginSiteID,COUNT(1) c,MAX(ID) ID FROM TJ_TB_Order GROUP BY OriginID,OriginSiteID
) A WHERE A.c>1) B ON O.OriginID=B.OriginID AND O.OriginSiteID=B.OriginSiteID AND O.ID=B.ID
原创文章，作者：ItWorker，如若转载，请注明出处：https://blog.ytso.com/tech/bigdata/289768.html