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
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