mysql 释放结果结,mysql – UNION ALL命令最终结果

我有以下查询成功生成结果.但是,结果是顺序的,我想通过两个名为clicks的表中的列来对它们进行排序

(SELECT women_id, title, body FROM women ORDER BY women_id DESC LIMIT 5)

UNION ALL

(SELECT man_id, title, body FROM man ORDER BY man_id DESC LIMIT 5)

现在它给出了这样的结果：

women 41124

women 124

women 12

women 2

women 1

men 3455434

men 1233

men 135

men 23

men 1

我需要它来给出这样的最终结果：

men 3455434

women 41124

men 1233

men 135

women 124

men 23

women 12

women 2

women 1

men 1

解决方法:

您需要将单击引入UNION-ed数据集,添加ORDER BY,然后使用另一个SELECT将不必要的列投影出来,如下所示：

SELECT person_id, title, body FROM ((

(SELECT women_id as person_id, title, body, clicks FROM women ORDER BY women_id DESC LIMIT 5)

UNION ALL

(SELECT man_id as person_id, title, body, clicks FROM man ORDER BY man_id DESC LIMIT 5)

) ORDER BY clicks DESC) data

标签：mysql

来源： https://codeday.me/bug/20190620/1243621.html