Database & 技术 19 Jun 2006 01:18 pm
使用week groupby 时可能出错
SELECT concat(year,lpad(month,2,0),lpad(day,2,0)) as mydate,week(concat(year,lpad(month,2,0),lpad(day,2,0)) ,3) as myweek FROM t_status WHERE concat(year,lpad(month,2,0),lpad(day,2,0)) >=20050606 GROUP BY myweek ORDER BY mydate DESC
当db中记录跨年时，使用week group by 应改成yearweek
SELECT concat(year,lpad(month,2,0),lpad(day,2,0)) as mydate,yearweek(concat(year,lpad(month,2,0),lpad(day,2,0)) ,3) as myweek FROM t_status WHERE concat(year,lpad(month,2,0),lpad(day,2,0)) >=20050606 GROUP BY myweek ORDER BY mydate DESC