590
社区成员
发帖
与我相关
我的任务
分享
--测试数据
if not object_id(N'Tempdb..#T') is null
drop table #T
Go
Create table #T([A] decimal(18,7),[B] decimal(18,7),[C] int)
Insert #T
select null,1,null union all
select 1,0.5,null union all
select 0.8,null,4
Go
--测试数据结束
SELECT SUM(ISNULL(A, 0) + ISNULL(B, 0) + ISNULL(C, 0))
/ SUM(CASE WHEN A IS NOT NULL THEN 1
ELSE 0
END + CASE WHEN B IS NOT NULL THEN 1
ELSE 0
END + CASE WHEN C IS NOT NULL THEN 1
ELSE 0
END)
FROM #T