Tag
Explains the subtle differences in how ORDER BY handles bare identifiers versus expressions in SQL, using PostgreSQL examples to show that identical-looking queries can produce different results due to different code paths.
The article traces the evolution of SQL's ORDER BY clause from the 1980s to modern standards, clarifying common misunderstandings about syntax and evaluation order.