SELECT * FROM [t1] ORDER BY (CASE WHEN [t1].[SortNumber] IS NOT NULL THEN [t1].[SortNumber] ELSE 9999 END)
order by,依次按[t1].[SortNumber]排。
case when 是当[t1].[SortNumber]是null的时候,[t1].[SortNumber]取9999进行排序
SELECT * FROM [t1] ORDER BY (CASE WHEN [t1].[SortNumber] IS NOT NULL THEN [t1].[SortNumber] ELSE 9999 END)
order by,依次按[t1].[SortNumber]排。
case when 是当[t1].[SortNumber]是null的时候,[t1].[SortNumber]取9999进行排序