SQL
`NULL` Order Modifier
By default, DuckDB sorts `ASC` and `NULLS LAST`, i.e., the values are sorted in ascending order and `NULL` values are placed last.
This is identical to the default sort order of PostgreSQL.
The default sort order can be changed with the following configuration options.  
Use the `default_null_order` option to change the default `NULL` sorting order to either `NULLS_FIRST`, `NULLS_LAST`, `NULLS_FIRST_ON_ASC_LAST_ON_DESC` or `NULLS_LAST_ON_ASC_FIRST_ON_DESC`:  
```sql
SET default_null_order = 'NULLS_FIRST';
```  
Use the `default_order` to change the direction of the default sorting order to either `DESC` or `ASC`:  
```sql
SET default_order = 'DESC';
```