SQL 列重复查询

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