MySQL:按周计算。(MySQL: counts by week.)
我想按周计算一系列计数。 我知道使用week()函数返回一周的数字,但我喜欢这样的东西:
Week count(*) Jan 1 - Jan 7 30 Jan 8 - 14 50 and so on...有没有办法做到这一点? 非常感谢你。
I would like to group a series of counts but by week. I know that using the week() function returns a number for the week, but i'd like something like this:
Week count(*) Jan 1 - Jan 7 30 Jan 8 - 14 50 and so on...Is there a way to do this? Thank you very much.
最满意答案
select concat(cast(DATE_ADD(yourdate, INTERVAL(1-DAYOFWEEK(yourdate)) DAY) as char), ' - ', cast(DATE_ADD(yourdate, INTERVAL(7-DAYOFWEEK(yourdate)) DAY) as char)) as period, count(*) from tablename group by week(yourdate) select concat(cast(DATE_ADD(yourdate, INTERVAL(1-DAYOFWEEK(yourdate)) DAY) as char), ' - ', cast(DATE_ADD(yourdate, INTERVAL(7-DAYOFWEEK(yourdate)) DAY) as char)) as period, count(*) from tablename group by week(yourdate)更多推荐
发布评论