mysql查询表里的某一字段的重复数据及数量

select * from (SELECT
字段名,COUNT(1) as c
FROM
    表名
WHERE
    1 = 1
GROUP BY 字段名) s
where s.c >1

效果如下：