SQL’s ORDER BY Has Come a Long Way (opens in new tab)

Order by Has Come a Long WayLimited support in union, except and intersect legsExpressions must not contain selected columnsThe order by clause is surely one of the best-known SQL clauses. Yet there are a number of common misunderstandings that are worth clearing up. For that, I’ll walk you through the evolution of the order by clause in ISO/IEC 9075-2:2023—that is, the SQL standard.The 1980sIn the beginning,0 the order by clause had several limitations that were lifted later: (1) it could on...