ORDER BY with UNION

Question

ORDER BY with UNION

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.