SQL月度统计
程序员文章站
2023-09-08 14:20:29
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 Conver ......
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)
上一篇: 怎样做油酥饼,家常油酥饼的做法
下一篇: redis实战---读书笔记