查询按周查找SUM

Question

我有一个类似日期，销售，地区的表格

33

需要选择分组前的星期。

这应该为您工作:

SELECT DATEPART(week, date) AS Week,
FROM table
GROUP BY DATEPART(week, RegistrationDate);