我试图在此查询中获取十进制值,但无法获取我得到 NULL 值
SELECT CAST(CAST(CAST(SUM(CAST(0 AS INT)) AS DECIMAL(10, 2)) * 100
/ CAST(NULLIF(SUM(CAST(0 AS INT))
+ SUM(CAST(0 AS INT)) +
SUM(CAST(0 AS INT)), 0)
AS DECIMAL(10, 2)) AS DECIMAL(10, 2)) AS DECIMAL)
如何获得输出
0.00
而不是此查询中的 null
使用 ISNULL 内置函数:
ISNULL(CAST(CAST(CAST(SUM(CAST(0 AS INT)) AS DECIMAL(10, 2)) * 100 / CAST(NULLIF(SUM(CAST(0 AS INT)) + SUM(CAST(0 AS INT)) + SUM(CAST(0 AS INT)), 0) AS DECIMAL(10, 2)) AS DECIMAL(10, 2)) AS DECIMAL), 0)
http://technet.microsoft.com/es-es/library/ms184325.aspx http://technet.microsoft.com/es-es/library/ms184325.aspx
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)