leehniu

select * from company where comid in (select Max(comid) from company group by companyname)得到重复记录数