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 ·
14015 阅读 ·
2 评论
关注
分享
扫一扫