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)
转载于:https://www.cnblogs.com/BillBlog/p/11196867.html
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)
转载于:https://www.cnblogs.com/BillBlog/p/11196867.html