sql查询总和为空的时候怎么给他赋值为零?

Question

select SUM(isNULL(score,0)) from ZWY_Subject where Users =11这个查询出来的是一个空值，原因是Users=11在ZWY_Subject表中不存在的。但是如果等于12的，score为空的话就可以赋值为0。因为Users=12在ZWY_Subject表有数据。求高手解决........

Answer 1

declare @kk float
set @kk =(select SUM(isNULL(score,0)) from ZWY_Subject where Users =11)
set @kk =isNULL(@kk ,0)

Answer 2

select sum(isnull(score,0)) from ZWY_Subject where Users =11

Answer 3

没明白你什么意思