select MyDate
from MyTable
order by case when MyDate is null then 1 else 0 end, MyDate

order by coalesce(date-time-field,large date in future)

order by -cast([nativeDateModify] as bigint) desc

select MyDate
from MyTable
order by case when MyDate is null then 1 else 0 end, MyDate

解决方案使用“case”是通用的，但不使用索引。

order by case when MyDate is null then 1 else 0 end, MyDate

就我而言，我需要表现。

 SELECT smoneCol1,someCol2  
 FROM someSch.someTab
 WHERE someCol2 = 2101 and ( someCol1 IS NULL ) 
  UNION   
 SELECT smoneCol1,someCol2
 FROM someSch.someTab
 WHERE someCol2 = 2101 and (  someCol1 IS NOT NULL)  

当你的排序列是数字(像一个秩)，你可以乘以-1，然后按顺序降序。它将保持您所期望的顺序，但将NULL放在最后。

select *
from table
order by -rank desc