首页 > 数据库技术 > 详细

SQL Server 按月统计订单量

时间:2014-08-29 17:51:10      阅读:250      评论:0      收藏:0      [点我收藏+]
Use Basket

select convert(varchar(7),Orderdate,120) as YearMonth
,OrderID
,TotalCost
into #a
from Basket.dbo.BaseOrderTracker(nolock)
where OrderDate >=‘2013-07-01‘
and OrderDate <=‘2014-07-31‘
and OrderTypeID = 15
and OESourceID = 2
and StageID= 10400



select * from #a

select YearMonth,
COUNT(distinct OrderID),
SUM(TotalCost)
from #a (nolock)
group by YearMonth

drop table #a

  

SQL Server 按月统计订单量

原文:http://www.cnblogs.com/monkeyfather/p/3945352.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!