SELECT * FROM tb ORDER BY (CASE WHEN CreateDate IS NULL THEN 1 ELSE 0 END), CreateDate
select * from table1 order by isnull(CreateDate,'2999-1-1')
22,209
社区成员
121,731
社区内容
加载中
试试用AI创作助手写篇文章吧