根据偏移量分组
with tmp as(
select 1001 as id,3 as num from dual union all
select 1001 as id,5 as num from dual union all
select 1001 as id,6 as num from dual union all
select 1001 as id,7 as num from dual union all
select 1002 as id,14 as num from dual
)
select id,num,dense_rank() over (order by (num - rownum)) rr from tmp;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/69996462/viewspace-2763356/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
带分区拷贝数据（自动创建分区）
下一篇：
缓慢变化维之拉链表
请登录后发表评论
登录
全部评论
