SqlServer 查询数据重复

最新推荐文章于 2024-08-12 03:07:58 发布

原创最新推荐文章于 2024-08-12 03:07:58 发布 · 1k 阅读

CC 4.0 BY-SA版权

文章标签：

1、查询单列重复

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

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