вот что пишут на сайте advantage:
Цитата:
Statements used in a UNION can only have ORDER BY clauses on the last statement of the UNION. If an ORDER BY clause is placed at the end of a UNION statement, the ORDER BY would apply to the result of the entire UNION, not just the last statement in the UNION. If a statement within the UNION must have an ORDER BY clause, the statement can be turned into a subquery, which then can have the ORDER BY.
|