使用sql语句统计重复某个字段出现重复次数

select 字段名,COUNT(0) AS 字段名 FROM 表名 GROUP BY 字段名 HAVING COUNT(字段名)>1