php - mysql按升序获取最新日期记录

Question

我有以下“统计”表:

我想要 mysql 查询返回最新的 5 个日期和点击总和。所以起始记录应该是2015-01-12

输出:

到目前为止，我已经编写了以下查询，但根据我的输出，该查询不起作用。

SELECT logdate, (
    SELECT SUM(clicks)
    FROM stats t2
    WHERE t2.logdate = t1.logdate
    ORDER BY t2.logdate
    DESC LIMIT 0,5
) as clicks
FROM stats t1
GROUP BY t1.logdate
ORDER BY t1.logdate ASC
LIMIT 0, 5

Answer 1

为什么要这么复杂的查询？你可以简单地做

SELECT logdate,sum(clicks) FROM stats
GROUP BY logdate 
ORDER BY logdate DESC
LIMIT 5

评论后编辑

SELECT * FROM
(
 SELECT logdate,sum(clicks) FROM stats
 GROUP BY logdate 
 ORDER BY logdate DESC
 LIMIT 5
) data
 ORDER BY logdate ASC

Fiddle