MySQL统计某列各字段的数量及某列中各字段占所有类型的百分比
SELECT SYSTEM,a.cnt,CONCAT(ROUND(a.cnt/b.sum *100,2),'','%')FROM (select SYSTEM, count(SYSTEM) AS cnt from nginx_log_resource GROUP BY SYSTEM ORDER BY cnt DESC )AS a,(SELECT COU...
原创
2018-08-22 16:57:59 ·
13824 阅读 ·
2 评论