NULLs are considered to be larger than any other value. By default order by is given the NULL values appear in the end . We can change this order using NULLS FIRST or NULLS LAST.
Ex:- SELECT *
FROM emp
ORDER BY comm NULLS LAST
SELECT *
FROM emp
ORDER BY comm NULLS FIRST