As of SQLite Release 3.30.1ORDER BY includes the NULLS FIRST and NULLS LAST options to express where to put NULL-rows. Usage examples of this syntax can be found here.
I'm dabbling with databases and what a joy litecli is compared to the sqlite3 shell. If I'm not mistaken, the above feature is missing from the current version of litecli (1.3.2) and would be nice to have :)
As of SQLite Release 3.30.1
ORDER BY
includes theNULLS FIRST
andNULLS LAST
options to express where to put NULL-rows. Usage examples of this syntax can be found here.I'm dabbling with databases and what a joy litecli is compared to the sqlite3 shell. If I'm not mistaken, the above feature is missing from the current version of litecli (1.3.2) and would be nice to have :)
Kind Regards