order by…nulls (first|last)

BigQueryDb2 (LUW)DuckDBH2MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite2007200920112013201520172019202120232025✓ 3.30.0 - 3.51.0⊘ 3.5.7 - 3.29.0a⊘ 2008R2 - 2025a✓ 8.3 - 18b✓ 11gR1 - 23.26.0b⊘ 5.0 - 9.5.0a⊘ 5.1 - 12.1.2a✓ 1.4.192 - 2.4.240a✓ 1.0.0 - 1.4.0cd✓ 11.1 - 12.1.2⊘ 9.7 - 10.5b✓ 2.0⊘ 2.0a
  1. Default: sorted as smallest
  2. Default: sorted as greatest
  3. Default: nulls last
  4. Configurable: set default_null_order = [NULLS_FIRST | NULLS_LAST | NULLS_FIRST_ON_ASC_LAST_ON_DESC | NULLS_LAST_ON_ASC_FIRST_ON_DESC]