ORDER BY inside a UNION member

Question

Accepted Answer

Standard SQL forbids ORDER BY inside an individual query that is part of a set operation. The correct pattern is a single ORDER BY clause placed after the last SELECT in the chain, which sorts the entire combined result. Some databases allow a workaround using a subquery: wrap the individual SELECT in parentheses, but even then the outer ORDER BY controls the final order.