Where does the NULL appear in the output?
-- PostgreSQL; score: 3, NULL, 1 SELECT score FROM t ORDER BY score;
- First
- Last
- It is left out
- In the middle
PostgreSQL sorts NULL as larger than any value, so ascending order puts it last (use
Play SQL & Databases ▸
NULLS FIRST to change).