sql server 查重 sql字段查重

1. SQL查重

 

-- SQL语法：SELECT 查重的列名 FROM 表名 GROUP BY 查重的列名 HAVING COUNT (查重的列名)>1
例：SELECT SPARETEXT1 FROM T_PRODUCTLOG GROUP BY SPARETEXT1  HAVING COUNT (SPARETEXT1)>1 
-- 查询相应重复数据的所有列
SELECT * FROM T_PRODUCTLOG WHERE SPARETEXT1 IN (SELECT SPARETEXT1 FROM T_PRODUCTLOG GROUP BY SPARETEXT1  HAVING COUNT (SPARETEXT1)>1)

 

1.1 查某列重复的字段

 

1.2 查多列都含重复的字段

SQL 语法：SELECT 查重的列名1，查重的列名2，...(此处也可以只写需显示的某一个含重复列名)  FROM 表名 GROUP BY 查重的列名1，查重的列名2，...  HAVING COUNT (查重的列名1)>1
例：SELECT SPARETEXT1,SPARETEXT2 FROM T_PRODUCTLOG GROUP BY SPARETEXT1,SPARETEXT2  HAVING COUNT (PROBERID)>1