mysql将小数转换成百分比_SQL语句小数变成百分数_香菜加馍-华为云开发者联盟

网站介绍:展开全部select convert(numeric(8,2) ,cast( (select convert(Numeric(8,2),( select COUNT(*) from 表 where 列1=1229)) /(select count(列1) from 表))) * 100 as varchar(10) ) + '%'注:*100 as varchar(10))+'%'(10... 香菜加馍 华为云开发者联盟