统计数据的SQL

  SELECT SUM(case when ml_WinMoney>0 then ml_WinMoney else 0 end) NUM,SUM(case when ml_WinMoney<0 then ml_WinMoney else 0 end),SUM(ml_winmoney)

,COUNT(DISTINCT UID) 

FROM dbo.M_T_WinMoney_List WHERE DATEDIFF(D,ML_ADDTIME,GETDATE())<1   ORDER BY NUM DESC