文章目录
1 概述
2 示例
2.1 nulls first:null 排最前面
with t_test as (
select null a from dual union all
select '1' a from dual union all
select '2' a from dual
)
select t.*
from t_test t
order by t.a nulls first;
执行结果:null 值排列最前
a
''
1
2
2.2 nulls last:null 排最后面
with t_test as (
select null a from dual union all
select '1' a from dual union all
select '2' a from dual
)
select t.*
from t_test t
order by t.a nulls last; -- ** 仅此处变化 **
执行结果:null 排列最后
a
1
2
''
2.3 null 默认最大
with t_test as (
select null a from dual union all
select '1' a from dual union all
select '2' a from dual
)
select t.*
from t_test t
order by t.a;
执行结果:null 排列最后
a
1
2
''