ORDER BY & NULL
Control whether NULL appears at the top or bottom of sorted results with
ORDER BY ... NULLS { FIRST | LAST }
This overrides the default sorting behaviour
ASC = NULLS LAST
DESC = NULLS FIRST
--
Need help with SQL?
Learn SQL in this free course https://devgym.oracle.com/pls/apex/dg...
Ask us over on AskTOM: https://asktom.oracle.com
Twitter: / chrisrsaxon
Daily SQL Twitter tips: / sqldaily
All Things SQL blog: https://blogs.oracle.com/sql/
Test your SQL Skills on the Oracle Dev Gym: https://devgym.oracle.com/
===========================
The Magic of SQL with Chris Saxon