SQL Server查询重复数据

2.查询多列重复

1 SELECT a.* FROM test a,(
2 SELECT name,code
3 FROM test 
4 GROUP BY name,code
5 HAVING COUNT(1)>1
6 
7 ) AS b
8 WHERE a.name=b.name AND a.code=b.code

SQL Server查询重复数据

标签：where   group   and   单列   serve   多列   code   bsp   font