原因主要是分母有问题,所以一般只需转换分母即可也可以分子分母一起转换
CAST(SUM(ACT_AMOUNT) AS FLOAT) / CAST(SUM(ACT_N) AS FLOAT) AS PRICE,
CAST(SUM(ACT_AMOUNT) AS FLOAT) / SUM(ACT_N) AS PRICE1,
DEC(SUM(ACT_AMOUNT),25,4)/ DEC(SUM(ACT_N),25,4) AS PRICE2,
DEC(SUM(ACT_AMOUNT),25,4)/ SUM(ACT_N) AS PRICE3