Order by Has Come a Long Way

2026-05-15

SQL's ORDER BY clause now supports non-selected columns, expressions, explicit null ordering, and use inside subqueries in modern SQL standards. SQL has three relevant “orders”—syntax, logical evaluation, and actual execution—so developers should trust execution plans over simplistic infographics about clause order or “filter early” advice.