SQL 列重复查询
1.查询某一列重复
SELECT Name FROM dbo.Member t WHERE Name IN (SELECT Name FROM dbo.Member GROUP BY Name HAVING COUNT(Name)>1 ) ORDER BY t.Name
2.查询两列重复
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
3.清处某列重复数据
DELETE FROM dbo.Member WHERE ID NOT IN (SELECT MIN(ID) FROM dbo.Member GROUP BY Name)
相关链接
https://blog.csdn.net/FairyStepWGL/article/details/69946628
https://www.cnblogs.com/lidabo/archive/2013/04/16/3024708.html
https://www.cnblogs.com/peida/archive/2011/11/12/2246463.html