SQL how to make null values come last when sorting ascending September 25, 2022 by Tarik select MyDate from MyTable order by case when MyDate is null then 1 else 0 end, MyDate