Sql 按日期带条件统计

select convert(char(8),[UseTime],112) dt,
sum([UseMoney]) 合计,
sum(case when [S_Number]=2 then UseMoney else 0 end ) as '状态2',
sum(case when [S_Number]=3 then UseMoney else 0 end ) as '状态3'
from [TX_DB].[dbo].[Fjc_Money_User]
group by convert(char(8),[UseTime],112) order by dt

posted @ 2015-11-17 17:05  末郁  阅读(211)  评论(0编辑  收藏  举报