- The ORDER BY clause can appear only once at the end of the compound query.
在混合查询中,order by语句只能在末尾出现一次。
- Component queries cannot have individual ORDER BY clauses.
混合查询中,每个单独的查询不能有order by语句。
- The ORDER BY clause recognizes only the columns of the first SELECT query.
order by语句只对第一条子查询语句起作用。
- By default, the first column of the first SELECT query is used to sort the output in an ascending order默认情况下,第一条子查询语句将对输出结果进行升序排序。