1、表dict 如下
2、统计字段‘中文’的每一行的数据重复次数
select count(*) as repeat_count,a.`中文` from `字典`a group by a.`中文` having repeat_count > 1;
重复两次
3、查询所有重复字段名称的数据
SELECT * FROM `字典` a WHERE a.`中文`
in(select b.`中文` from `字典`b group by b.`中文` having count(*) > 1) AND a.`中文`!='' ORDER BY a.`中文`