order by datatime desc 这样的句子也一样 不管是正排还是倒排 为空的都在最前!
9 个解决方案
#1
求回复啊!木有人吗?在线等啊!
#2
order by datatime nulls last
order by datatime desc nulls last
order by datatime desc nulls last
#3
order by nvl(time,to_date('1900-01-01','yyyy-mm-dd')) desc
试下
试下
#4
order by xx nulls last
#5
order by .. nulls last
#6
nulls last
#7
nulls last
#8
order by xx nulls last
#9
这个可以实现
#1
求回复啊!木有人吗?在线等啊!
#2
order by datatime nulls last
order by datatime desc nulls last
order by datatime desc nulls last
#3
order by nvl(time,to_date('1900-01-01','yyyy-mm-dd')) desc
试下
试下
#4
order by xx nulls last
#5
order by .. nulls last
#6
nulls last
#7
nulls last
#8
order by xx nulls last
#9
这个可以实现