SQL Server 一列或多列重复数据的查询，删除

SELECT m.* FROM dbo.Match m,(
SELECT Original_ID,Match_ID
FROM dbo.Match 
GROUP BY Original_ID,Match_ID
HAVING COUNT(1)>1

) AS m1
WHERE m.Original_ID=m1.Original_ID AND m.Match_ID=m1.Match_ID

查询结果

SQL Server 一列或多列重复数据的查询，删除

标签：strong   name   not   let   server   src   一个   sel   分享