SqlServer获取一周内每天的金额统计数据

最新推荐文章于 2024-02-06 15:53:31 发布

xiaobingge2018

最新推荐文章于 2024-02-06 15:53:31 发布

阅读量1.5k

点赞数

文章标签： SqlServer

本文链接：https://blog.csdn.net/xiaobingge2018/article/details/103830406

版权

select  datename(weekday,CAST([CompletedTime] AS date)) WeekNum,  
CAST([CompletedTime] AS date) AS 'Date' , 
SUM(case when OrderStatus=2 and IsDeleted=0 then  PlatformAmount else 0 end) as PlatformAmount,
SUM(case when OrderStatus=2 and IsDeleted=0 then  AgentAmount else 0 end)  as AgentAmount,
SUM(case when OrderStatus=2 and IsDeleted=0 then  TenantAmount else 0 end) as TenantAmount
from QYNET_Order where datediff(week,CompletedTime,getdate()-1)=0 
group by CAST([CompletedTime] AS date) 
order by Date

其中 CompletedTime就是时间,下面是查询结果