SqlServer 查询数据重复

SQL Server 查询数据重复

1、查询单列重复

select * from test
where name in (select name from test group by name having count
(name) > 1)

2、查询多列重复

SELECT a.* FROM test a,(
SELECT name,code
FROM test 
GROUP BY name,code
HAVING COUNT(1)>1
 
) AS b
WHERE a.name=b.name AND a.code=b.code

————————————————
版权声明：本文为CSDN博主「Laity_MM」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.csdn.net/lyq1269016829/article/details/125103163