- 博客(1)
- 收藏
- 关注
RSS订阅转载 SqlServer查询重复数据
SqlServer查询重复数据 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.nam
2021-08-24 10:58:59
9583
1
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人