SELECT *          
FROM Employees
ORDER BY ISNULL(DepartmentId, 99999);

请看这篇博客文章。

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

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)  

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

SELECT *          
FROM Employees
ORDER BY ISNULL(DepartmentId, 99999);

请看这篇博客文章。