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 末郁 阅读(...) 评论(...) 编辑 收藏