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

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

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

解决方案使用“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)  

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

(“有点”晚了，但这一点根本没有被提及)

您没有指定您的DBMS。

在标准SQL(以及大多数现代DBMS，如Oracle, PostgreSQL, DB2, Firebird, Apache Derby, HSQLDB和H2)中，您可以指定NULLS LAST或NULLS FIRST:

使用NULLS LAST将它们排序到最后:

select *
from some_table
order by some_column DESC NULLS LAST