- 博客(1)
- 收藏
- 关注
转载 SqlServer查询重复数据
SqlServer查询重复数据1.查询单列重复:select * from testwhere name in (select name from test group by name having count(name) > 1)2.查询多列重复:复制代码SELECT a.* FROM test a,(SELECT name,codeFROM testGROUP BY name,codeHAVING COUNT(1)>1) AS bWHERE a.name=b.nam
2021-08-24 10:58:59 9273 1
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人