【需要处理的数据】,里面放sql查询
select CAST(CONVERT( DECIMAL(18,2),(需要处理的数据)*100) AS VARCHAR(10))+'%' as 百分比
例如:
select CAST(CONVERT(DECIMAL(18,2),SUM(C21.YFGZ)/(select SUM(YFGZ) from c21 where c21.GZ_YM=201902 )*100)AS VARCHAR(10))+'%' AS 分店工资占比 from A01,C21 where
a01.A0188=c21.A0188 and c21.GZ_YM=201902
group by A01609,GZ_YM
效果如图所示: