SQLServer 查询数据重复
- SqlServer
- 2024/1/24 16:51:13
- 人已阅读
简介
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
文章评论
- 消灭零回复