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

select mark_name ,COUNT(0) AS 重复数据 FROM livemark GROUP BY mark_name HAVING COUNT(mark_name)>1 ORDER BY 重复数据 DESC