nullsort¶
nullsort setting sets whether NULL should be sorted as low or high.
This is an interpreter level setting.
By default, it is low.
Syntax¶
usage: .set nullsort [low | high]
Executing the setting without arguments will display the nullsort setting for the current interpreter.
Example¶
.set nullsort low
.sort a DESC
SELECT * FROM MyTable;
.set nullsort high
.sort a DESC
SELECT * FROM MyTable;