select name, count(name) from t group by name having count(name)= (select max(a.cou) from (select count(name) as cou from t group by name) a )本回答被提问者采纳
第2个回答 2012-11-18
select top 1 name,count(name) from table group by name order by count(name) desc本回答被网友采纳