NULLS FIRST / NULLS LAST

Question

Accepted Answer

NULLS FIRST overrides the default NULL ordering and puts NULL values before all non-NULL values regardless of ASC/DESC. Alice has NULL manager_id, so she comes first. Bob and Carol both have manager_id = 1, so their relative order is stable - Bob (id 2) before Carol (id 3) by insertion order.