mysql - 使用mysql从表中获取下一个最后n个元素

Question

我有一个这样的表来跟踪每小时对我网站的访问:

id  | year | month | day | hour | date          | visit
 1    1391    12      1     10     2012-11-10       15
...    ...    ...    ...   ...         ...              ...

我使用此查询来获取最近 7 天的访问者数量。

SELECT Sum(visit), `day`, `month`, `year`, WEEKDAY(date) as wd 
FROM tablename GROUP BY date ORDER BY date DESC LIMIT 7;

现在我的问题是:如何获取这 7 天之前的 7 天？

(年、日、月是我本地的日期格式，我想在注册时更改一次)

Answer 1

使用偏移:

SELECT Sum(visit), `day`, `month`, `year`, WEEKDAY(date) as wd 
FROM tablename
GROUP BY date
ORDER BY date DESC
LIMIT 7 OFFSET 7;