mysql求和 子查询_mysql – 对几个查询的结果进行求和,然后在...

这个问题留下了解释的空间.要UNION所有三个查询的结果行,然后选择具有最高“金额”的5行：

(SELECT event_id, count(*) AS amount

FROM pageview

GROUP BY event_id

ORDER BY pageviews DESC, rand()

LIMIT 1000)

UNION ALL

(SELECT event_id, count(*)

FROM upvote

GROUP BY event_id

ORDER BY upvotes DESC, rand()

LIMIT 1000)

UNION ALL

(SELECT event_id, count(*)

FROM attending

GROUP BY event_id

ORDER BY attendants DESC, rand()

LIMIT 1000)

ORDER BY 2 DESC

LIMIT 5;

To apply ORDER BY or LIMIT to an individual SELECT, place the clause

inside the parentheses that enclose the SELECT.

UNION ALL,因此不会删除重复项.

如果要为每个event_id添加计数,则此查询应执行此操作：

SELECT event_id, sum(amount) AS total

FROM (

(SELECT event_id, count(*) AS amount

FROM pageview

GROUP BY event_id

<