MySQL根据日期列按周分组吗? [英] MySQL grouping by week, based on a date column?

问题描述

我有一个带有日期列的表，我想使用一周作为时间参考来尝试分组，以计算每周发生的行数.我已经使用GROUP BY Date(Date_Column)完成了几天的工作，但是我不确定如何按周执行此操作?

I have a table with a date column and I would like to try and group by, using a week as a time reference in order to count how many rows occured per week. I have done this for days, using GROUP BY Date(Date_Column) but i'm unsure how to do this by week?

谢谢

推荐答案

SELECT ...
FROM ....
GROUP BY YEAR(Date_column), WEEKOFYEAR(Date_Column);

这篇关于MySQL根据日期列按周分组吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！