DB2函数配合
select row_number() over(order by col desc nulls first/nulls last ) as rn,col from table1order by rn;
nulls first:把空值放到最前面,再对非空值排序
nulls last:把空值放到最后面在对非空值排序
DB2排序和包含空值排序
最新推荐文章于 2023-07-06 18:40:25 发布
DB2函数配合
select row_number() over(order by col desc nulls first/nulls last ) as rn,col from table1order by rn;
nulls first:把空值放到最前面,再对非空值排序
nulls last:把空值放到最后面在对非空值排序