ORDER BY 和 LIMIT 后的 UNION

UNION after ORDER BY and LIMIT(ORDER BY 和 LIMIT 后的 UNION)
本文介绍了ORDER BY 和 LIMIT 后的 UNION的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我的目标是执行两个不同的查询,然后将它们组合起来.
我的代码是:

My goal is to execute two different queries and then combine them.
My code is:

SELECT * FROM some tables WHERE ... ORDER BY field1 LIMIT 0,1 
UNION   
SELECT * FROM some tables WHERE ...

我收到以下错误:

#1221 - UNION 和 ORDER BY 的错误使用

#1221 - Incorrect usage of UNION and ORDER BY

ORDER BY 仅用于第一个查询很重要.我该如何执行此任务?

It is important that ORDER BY is only for the first query. How can I perform this task?

推荐答案

您可以使用括号来允许对单个查询使用 ORDER/LIMIT:

You can use parenthesis to allow the use of ORDER/LIMIT on individual queries:

(SELECT * FROM some tables WHERE ... ORDER BY field1 LIMIT 0, 1)
UNION   
(SELECT * FROM some tables WHERE ...)
ORDER BY 1   /* optional -- applies to the UNIONed result */
LIMIT 0, 100 /* optional -- applies to the UNIONed result */

这篇关于ORDER BY 和 LIMIT 后的 UNION的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!

本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除!

相关文档推荐

Execute complex raw SQL query in EF6(在EF6中执行复杂的原始SQL查询)
Hibernate reactive No Vert.x context active in aws rds(AWS RDS中的休眠反应性非Vert.x上下文处于活动状态)
Bulk insert with mysql2 and NodeJs throws 500(使用mysql2和NodeJS的大容量插入抛出500)
Flask + PyMySQL giving error no attribute #39;settimeout#39;(FlASK+PyMySQL给出错误,没有属性#39;setTimeout#39;)
auto_increment column for a group of rows?(一组行的AUTO_INCREMENT列?)
Sort by ID DESC(按ID代码排序)