select cola, max(substr(sys_connect_by_path(colb, '+'), 2)) colb from (
select cola, colb, colc, lead(colc) over(partition by cola order by colc) cold from (
select cola, colb, row_number() over(order by cola, colb) colc from tab) )
start with cold is null
connect by prior colc=cold
group by cola;
select cola, colb, colc, lead(colc) over(partition by cola order by colc) cold from (
select cola, colb, row_number() over(order by cola, colb) colc from tab) )
start with cold is null
connect by prior colc=cold
group by cola;
解决方案 »
- 高分求 虚拟机配置oralcle RAC 教程
- 数据库移植,急,在线等。
- 我linux4.0下安装了oracle10j 但在使用startup是出现问题了
- 关于临时表 和 临时表空间的使用问题!!!!!!!!在线等待!!!!!!!!!!
- 急~~在线求教一个行转列的方法!!!!
- 求一条超高难度的SQL语句,跟贴有分。
- 想保存 CHR(149)||CHR(146) 到字段.
- help!!
- 请问SQL语句的表名前为什么加上SCOTT.才能找到,否则找不到表
- 请教BLOB类型的建立问题!
- 用过MS sql server2000 DTS 与oracle导数据和建表的XD进来。。
- ORA-08103: object no longer exists 紧急求助
本版精华区就有,要善加利用论坛资源
from (select code,name,
(row_number() over(order by code,name desc)
+ dense_rank() over(order by code)) rn,
max(name) over(partition by code) qs
from t_bi_branch
)
start with name = qs
connect by rn-1 = prior rn
group by code