--查询指定字段 重复记录大于一条的记录,并统计该记录出现的总次数
select b.ent_name,count(ent_name) from z_huhehaote_ent_item b group by b.ent_name having count(b.ent_name) > 1
select b.ent_name,count(ent_name) from z_huhehaote_ent_item b group by b.ent_name having count(b.ent_name) > 1