`Order by` Has Come a Long Way
Summary
This article traces the evolution of the SQL ORDER BY clause across major engines and standards, clarifying syntactic vs. logical vs. actual execution order, non-selected columns, expressions, and null ordering. It includes examples and notes on cross-database support and performance considerations for developers and DBAs.