- 先对周聚合,2. 去除当期周最小的日期
select
WEEKOFYEAR(STR_TO_DATE(t1.biz_date_id, '%Y%m%d')) as `周`,
min(STR_TO_DATE(t1.biz_date_id, '%Y%m%d')) as `日期`,
from temp
select
WEEKOFYEAR(STR_TO_DATE(t1.biz_date_id, '%Y%m%d')) as `周`,
min(STR_TO_DATE(t1.biz_date_id, '%Y%m%d')) as `日期`,
from temp