select yljgksmc ,xmbm ,count(1)from tablegroup by yljgksmc ,xmbmhaving count(1) > 1
select yljgksmc from biao4 group by ylgksmc having count(*) >'1'
