MySQL查询出的数据分组及计算出占总数的百分率，如下：

分别有字段：verify_id（唯一）     city_id

http://s15/mw690/00256vfIgy6L2chvwFo1e&690

SELECT count(`verify_id`) as `num`,`city_id`,round(count(`verify_id`)/(select count(*) from `verify_extend` )*100,2) as `percent` FROM `verify_extend`  group by `city_id` order by `percent` desc 

http://s16/mw690/00256vfIgy6L2ckJCPR7f&690