引用文档，
要将ORDER BY或LIMIT应用于单个SELECt，请将子句放在包围SELECT的括号内：
(SELECT a FROM t1 WHERe a=10 AND B=1 ORDER BY a LIMIT 10)UNIOn(SELECt a FROM t2 WHERe a=11 AND B=2 ORDER BY a LIMIT 10);
引用文档，
要将ORDER BY或LIMIT应用于单个SELECt，请将子句放在包围SELECT的括号内：
(SELECT a FROM t1 WHERe a=10 AND B=1 ORDER BY a LIMIT 10)UNIOn(SELECt a FROM t2 WHERe a=11 AND B=2 ORDER BY a LIMIT 10);
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
