SQL’s ORDER BY: From Alphabetical Sort to Data Wizardry

Remember when ORDER BY was just a way to sort employee names alphabetically? Like a calculator with a single button. But SQL didn’t stay still — its evolution is like upgrading from a Nokia 3310 to an iPhone 16.

Modern ORDER BY can do so much more: sorting by expressions, handling NULLs, window functions, and now support for complex data types. Developers used to plain ORDER BY name might experience culture shock seeing ORDER BY json_extract(data, '$.price') DESC NULLS LAST. It’s like going from a bicycle to a rocket.

It’s amusing how some still do ORDER BY on the client, claiming “SQL is too complicated.” But the truth is, modern SQL is a Swiss Army knife for data. Not using its capabilities is like ordering pizza but eating only the box.

By the way, for those still writing ORDER BY 1 instead of column names: we know who you are. And yes, it works, but your code looks like it was written by yesterday’s intern.

METABYTE studio comment: SQL isn’t just a query language — it’s an art. At METABYTE, we help projects not only write proper ORDER BY but also build architectures where data doesn’t make you cry. Though sometimes it does — but that’s another story.