mysql中计算百分比

最新推荐文章于 2024-07-21 03:26:23 发布

Say Bay To The Bugs

最新推荐文章于 2024-07-21 03:26:23 发布

阅读量2.3k

点赞数 1

分类专栏： MYSQL 文章标签： mysql百分比

本文链接：https://blog.csdn.net/qq_42678469/article/details/102784950

版权

MYSQL 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

使用ROUND函数:ROUND(num，保留小数位)

SELECT
	ROUND( b.num / a.num * 100, 1 ) AS bz,
	ROUND( c.num / a.num * 100, 1 ) AS hz,
	ROUND( d.num / a.num * 100, 1 ) AS zd,
	ROUND( e.num / a.num * 100, 1 ) AS zx,
	ROUND( f.num / a.num * 100, 1 ) AS xl,
	ROUND( g.num / a.num * 100, 1 ) AS qt 
FROM
	( SELECT count( id ) AS num FROM biz_table ) a,
	( SELECT count( id ) AS num FROM biz_table WHERE type = '1' ) b,
	( SELECT count( id ) AS num FROM biz_table WHERE type = '2' ) c,
	( SELECT count( id ) AS num FROM biz_table WHERE type = '3' ) d,
	( SELECT count( id ) AS num FROM biz_table WHERE type = '4' ) e,
	( SELECT count( id ) AS num FROM biz_table WHERE type = '5' ) f,
	( SELECT count( id ) AS num FROM biz_table WHERE type = '6' ) g

Say Bay To The Bugs

关注

1
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
mysql中计算百分比

使用ROUND函数:ROUND(num，保留小数位)SELECT ROUND( b.num / a.num * 100, 1 ) AS bz, ROUND( c.num / a.num * 100, 1 ) AS hz, ROUND( d.num / a.num * 100, 1 ) AS zd, ROUND( e.num / a.num * 100, 1 ) AS zx, RO...
复制链接

扫一扫

专栏目录