select b.ent_name,count(ent_name) from z_huhehaote_ent_item b group by b.ent_name having count(b.ent_name) > 1 转载于:https://my.oschina.net/u/3559601/blog/995215