ORDER BY expressions in SQL

Friendly reminder: when you ORDER BY something in SQL, that something does not necessarily need to be a column, but could be an expression, the output of which can be ordered.

In the example below, we'd like to ORDER by sales decreasingly, but show the 'direct' sales first.

This is achieved by using a CASE WHEN that will rank direct sales above other types of sales, then sorting by the sales decreasingly.

Found it useful? Check out to my Analytics newsletter at notjustsql.com.

---

Enjoyed this? Here are some related articles you might find useful:

• 9 tips on writing cleaner SQL
• Order of precedence in SQL: WHERE vs HAVING
• Easy with that SELECT DISTINCT!
• Why you should use parentheses with AND & OR in SQL