计算百分比变化返回 0

Question

我试图找到float的百分比变化，但是查询返回0.00

SELECT CAST(((SELECT 115301-(SELECT 114256))/(SELECT 114256))*100 AS DECIMAL(18,2))

我在这里错过了什么吗？我应该在哪里编辑 SQL？

Answer 1

在下面尝试它会起作用

SELECT CAST(CAST((115301-114256) AS FLOAT)/114256*100 AS DECIMAL(18,2))

Answer 2

试试这个：

SELECT CAST(((SELECT 115301.00- (SELECT 114256.00))/(SELECT 114256.00))*100 AS DECIMAL(18,2))

或

将数字转换为浮点数或十进制

SELECT CAST(((SELECT cast(115301 AS DECIMAL(18,2)) - (SELECT cast(114256 AS DECIMAL(18,2))))/(SELECT cast(114256 AS DECIMAL(18,2))))*100 AS DECIMAL(18,2))