查找表中重复记录,重复记录是根据单个字段来判断,并统计重复次数
SELECT [重复字段],COUNT(0) AS num FROM [表名]GROUP BY [重复字段] HAVING COUNT([重复字段]) > 1