Back to Code Snippets
Matt Holden
@holden.matt-1
Put null values last when sorting (like Excel or Postgres)
Editor's note: DuckDB enables you to configure whether NULL values are returned first or last in result sets by default. You can also specify it per query using NULLS LAST in the query ORDER BY clause. Note that NULLS LAST is now the default with 0.8.0+.
Execute this SQL
PRAGMA default_null_order='NULLS LAST';
Copy code
Matt Holden
Expand
Share link