If you sort a table from a field which has null values, Null values are typically displayed first.
Here is a way to display the NULL values at last.
Use NorthWindGOSelect * from employeesorder bycase when reportsTo is null then 1 Else 0 end,reportsTo