SQLServer 按日，周，月，季，年统计

SQLServer 按日，周，月，季，年统计

日，周，月，季，年时间段统计的便利方法

在做周统计的时候，客户要求从周一开始到周本结束算一周

--按日select sum(xxxx),day([date]) from XXXXXDataTable where year([date]) = '2017' group by day([date])--按周这里，有一个每周开始日的问题SET DATEFIRST 1;--星期一做每周第一天--按周select sum(xxxx),datename(week,[date]) from XXXXXDataTable where year([date]) = '2017' group by datename(week,[date])--按月select sum(xxxx),month([date]) from XXXXXDataTable where year([date]) = '2017' group by month([date])--按季select sum(xxxx),datename(quarter,[date]) from XXXXXDataTable where year([date]) = '2017' group by datename(quarter,[date]) --按年select sum(xxxx),year([date]) from XXXXXDataTable where  group by year([date])

留下思路。