Recently, I met a sort problem on the null values, a record on sorted column is null, and this record always display on top even if the sort is asc or desc.

How To Sort

No 1

SELECT date
FROM MyTable
ORDER BY CASE WHEN date IS NULL THEN 1 ELSE 0 END, date

No 2

SELECT MyDate
FROM MyTable
ORDER BY date IS NULL, date DESC

FYI: click here to get more information.