现在的查询代码是
select UserID,SUM(Jifen) as jifen1 from JifenList where datediff(MONTH,time,getdate())=0 group by JifenList.UserID order by jifen1 desc
查询 ID里 积分的总和在特定的月份的排名。
但是现在出现个问题， 就是jifen1表里 有正数，有负数， 查询出来的数据 跟我想要获得的数据不一样， 请大神指教，如何只查询正数的总和 刨除负数的数据呢？感谢大神！
简单来说 就是统计 jifen1 表里 大于0的数据， 大神请解惑
------解决方案--------------------
select UserID,SUM(Jifen) as jifen1 from JifenList
where datediff(MONTH,time,getdate())=0
and Jifen > 0
group by JifenList.UserID order by jifen1 desc
------解决方案--------------------
select UserID,
jifen1 =SUM(case when Jifen>0 then Jifen else 0 end)
from JifenList
where datediff(MONTH,time,getdate())=0
group by JifenList.UserID
order by jifen1 desc
------解决方案--------------------
select UserID,
sum(case when Jifen>0 then Jifen else 0 end) 'jifen1'
from JifenList
where datediff(month,[time],getdate())=0
group by UserID
order by jifen1 desc