Показать сообщение отдельно
  #2  
Старый 29.10.2019, 15:37
mars0n mars0n вне форума
Прохожий
 
Регистрация: 29.10.2019
Сообщения: 3
Версия Delphi: delphi 7
Репутация: 10
По умолчанию

вот что пишут на сайте 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.
Ответить с цитированием