orderbynull

# ORDER BY with nullable columns
# In MySQL they will be placed before everything. 
# But the intention of the application or the UX may need a different sort order. 
# In these cases the ordering for NULL values can be changed easily.


-- Default behaviour: NULL values placed first
SELECT * 
FROM customers ORDERBY country ASC;
-- NULL values placed first by rule

SELECT * 
FROM customers 
ORDER BY country ISNOTNULL, country ASC;
-- NULL values placed last by rule

SELECT*
FROM customers 
ORDER BY country ISNULL, country ASC;