日期:2014-05-18 浏览次数:20436 次
select class,count(1) as cnt from table order by cnt desc ------解决方案--------------------
select [类别] = class, [企业数量]=count(1) from table group by class order by 2 desc