如何从联合结果中选择? [英] How to select from union result?

问题描述

我有一个这样的MySQL脚本:

I have a MySQL script like this:

SELECT ... FROM ... WHERE ...
UNION ALL
SELECT ... FROM ... WHERE ...

现在如何再次从并集结果中进行选择?

now how to select again from the union result?

这不起作用:

SELECT * FROM (
    SELECT ... FROM ... WHERE ...
    UNION ALL
    SELECT ... FROM ... WHERE ...
);

推荐答案

您需要为内部查询放置一个别名:

You need to put an alias for the inner query:

SELECT * FROM (
    SELECT ... FROM ... WHERE ...
    UNION ALL
    SELECT ... FROM ... WHERE ...
) as something;

这篇关于如何从联合结果中选择?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！