round( 字段 / 字段 , 保留小数位数)
注意: COUNT(p.id)/c.sum 计算时,不能使用别名代替,否则报错(全部数学运算都是)
select
COUNT(p.id) as package_count,
c.sum,
ROUND(COUNT(p.id)/c.sum,3) as proportion
from t_order o, t_package p, (select COUNT(1) SUM from t_order) c
where o.package_id = p.id group by p.id order by package_count desc limit 0,4
查询结果:
百分比:
concat(字段,’%’) 先round计算数值,再拼接 %
select
COUNT(p.id) as package_count,
c.sum,
CONCAT(ROUND(COUNT(p.id)/c.sum * 100 ,3),’%’) as proportion
from t_order o, t_package p, (select COUNT(1) SUM from t_order) c
where o.package_id = p.id group by p.id order by package_count desc limit 0,4
查询结果:
了解更多分析及数据抓取可查看:
http://cloud.yisurvey.com:9081/html/529942a8-212c-4c85-9c92-9c56beb4a299.html?ly=csdn
特别说明:本文旨在技术交流,请勿将涉及的技术用于非法用途,否则一切后果自负。如果您觉得我们侵犯了您的合法权益,请联系我们予以处理。