它很好地满足了我的需求。我的查询现在是:
select *
from tableName
order by case when ordernum is null then 1 else 0 end, ordernum
SQL Server 2005:末尾带有NULL值的订单
它很好地满足了我的需求。我的查询现在是:
select *
from tableName
order by case when ordernum is null then 1 else 0 end, ordernum