放逐忧伤

摘要： 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 阅读全文