sql代码如下：

统计重复的数据

select MingCheng from tabShouFeiGongShi group by MingCheng having count(MingCheng) >= 2

select * from

(select *

from tabShouFeiGongShi

where  MingCheng in (select MingCheng from tabShouFeiGongShi group by MingCheng having count(MingCheng) >= 2)) t  order by MingCheng