Oracle order by null 值排到最前面（nulls first）

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
''

3 扩展

3.1 null 有哪些注意事项【面试题】

• Oracle null 有哪些注意事项【面试题】