select sum(a.TOTAL) TOTAL,
sum(a.TOTAL) - (select sum(b.TOTAL) from TONGZHOU.POPULATION_ANALYSIS_NUM b where 1 = 1 AND b.YEAR_MONTH = ‘2020-03’ AND b.POPU_TYPE = 01 ) incrementnum ,
Convert(decimal(10,4),round( ab**s*(s*um(a.TOTAL) - (select sum(b.TOTAL) from TONGZHOU.POPULATION_ANALYSIS_NUM b where 1 = 1 AND b.YEAR_MONTH = ‘2020-03’ AND b.POPU_TYPE = 01 ))*1.0 / (select sum(b.TOTAL) from TONGZHOU.POPULATION_ANALYSIS_NUM b where 1 = 1 AND b.YEAR_MONTH = ‘2020-03’ AND b.POPU_TYPE = 01 ),4))100 grow
from TONGZHOU.POPULATION_ANALYSIS_NUM a where 1 = 1 AND a.YEAR_MONTH = ‘2020-04’ AND a.POPU_TYPE = 01
1.round(xx1.0/yy,2) 乘以1.0可以取到0.00的数据
2.Convert(decimal(10,4),xx)可以截取到4位小数
sql语句获取小数0.00(round与convert配合使用)
最新推荐文章于 2022-02-16 15:41:46 发布