mysql
按照周分组
select yearweek(date_format,1),…
from table group by yearweek(date_format,1)
yearweek(date_format,1)或者WEEK(date,mode)
mysql
按照周分组
select yearweek(date_format,1),…
from table group by yearweek(date_format,1)
yearweek(date_format,1)或者WEEK(date,mode)