110,535
社区成员
发帖
与我相关
我的任务
分享
SELECT * from TB ORDER BY [列名] <>0 AND [列名]=0 DESC
SELECT * FROM TB ORDER BY (CASE WHEN [列名] > 0 THEN [列名] ELSE 9999 END)
SELECT * FROM TB ORDER BY (IIF([列名] > 0, [列名], 9999))
select * from TB order by case when [列名] is null then (select isnull(MAX([列名]),0) from TB)+1 else [列名] end asc