数据库统计某个字段个数(重复数)

统计某字段重复记录

select 字段名, count(字段名) from test group by name having count(字段名) > 1;

原文地址:https://www.cnblogs.com/alphajuns/p/12891286.html