support of nulls first / last in order clause
"NULLS LAST" is part of the SQL 99 standard.
The syntax is as follows:
ORDER BY [COLUMN NAME] [ASC | DESC] [NULLS FIRST | NULLS LAST]
In different DBs, the sorting of nulls relative to other values is handled differently.
PostgreSQL - Nulls are considered HIGHER than non-nulls.
DB2 - Higher
MSSQL - Lower
MySQL - Lower
Oracle - Higher
The following DBs have supported this functionality:
PostgreSQL, MySQL, SQLServer do not appear to support this from what I can gather.