SQL月度统计

select Convert ( VARCHAR(7),CreateTime,120) as Date ,sum(Money) as M FROM [LBAmmeterDB].[dbo].Am_Task
where OperateType=4 and Status=1
group by Convert ( VARCHAR(7), CreateTime, 120)

posted @ 2019-07-16 19:08  末郁  阅读(...)  评论(...编辑  收藏