我有以下“统计信息”表:
我想要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
为什么会有如此复杂的查询?你可以简单地做
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
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句