Code
SELECT Column1, Column2,Column3,Column4 FROM T_Table GROUP BY Column1, Column2 ,Column3,Column4 HAVING Count(1)>1DELETE T_Table
WHERE Id IN (SELECT a.Id
FROM T_Table a
WHERE EXISTS (
SELECT b.Id
FROM T_Table b
WHERE b.Column1 = a.Column1
AND b.Column2 = a.Column2
AND b.Column3 = a.Column3
AND b.Column4 = a.Column4
AND b.Id<a.Id
))
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。