使用 group by 分组之后 查询的数据 只能是 聚合函数 和 分组的本身字段
可以使用命令
SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
将 nly_full_group_by 置空
求最近五周的统计
SELECT *
FROM
(
SELECT WEEK
( date_sub( curdate( ), INTERVAL 5 WEEK ), 1 ) AS a UNION
SELECT WEEK
( date_sub( curdate( ), INTERVAL 4 WEEK ), 1 ) AS a UNION
SELECT WEEK
( date_sub( curdate( ), INTERVAL 3 WEEK ), 1 ) AS a UNION
SELECT WEEK
<