NULL sort order across databases

Question

Accepted Answer

T-SQL (SQL Server) treats NULL as less than any non-NULL value, so NULLs sort first in ASC order. PostgreSQL treats NULL as greater than any non-NULL value, so NULLs sort last in ASC. MySQL also sorts NULLs first in ASC. Because the behavior is engine-specific, always write NULLS FIRST or NULLS LAST explicitly when null sort position matters to your application.