CONCAT(sum(if(pp.phone_status=0,pp.count,0)),'(',CAST(ROUND(sum(if(pp.phone_status=0,pp.count,0))/sum(pp.count)*100,2) AS CHAR),'%)') as status0,
mybatis 查询随笔 (经过计算的数字类型一定要转成字符串,不然就会乱码)
最新推荐文章于 2024-07-11 00:25:41 发布
CONCAT(sum(if(pp.phone_status=0,pp.count,0)),'(',CAST(ROUND(sum(if(pp.phone_status=0,pp.count,0))/sum(pp.count)*100,2) AS CHAR),'%)') as status0,