Where does ORDER BY live in a UNION?

Question

Accepted Answer

ORDER BY applies to the combined result of the entire UNION, not to individual queries within it. Placing ORDER BY inside one of the UNION's sub-queries is not valid in standard SQL and will cause an error in most databases. Write: SELECT ... UNION SELECT ... ORDER BY column - the ORDER BY at the end sorts the final combined result.