我有一个这样的查询: SUM(report.impressions) AS impressions,
SUM(report.revenue) AS revenue,5条记录。我也希望有5个最高印象的记录计数。,我不想执行相同的查询两次,因为必须重新计算总和。有没有办法在不做两次求和的情况下获得收入前5名和印象<em
如果SELECT SUM(amount) FROM transactions ORDER BY order LIMIT 0, 50与表中的前50条记录的amount字段之和,那么在前50条记录之后如何算出所有记录的总和换句话说,我想做一些类似SELECT SUM(amount) from transactions ORDER BY order LIMIT 50, *的</e