select id,max(sys_connect_by_path(value,',')) result from
(
select id,value,rn,lead(rn) over(partition by id order by rn) rn1
from (
select id,value,row_number() over(order by id,value desc) rn from table1
)
)
start with rn1 is null
connect by rn1 = prior rn
group by id;
(
select id,value,rn,lead(rn) over(partition by id order by rn) rn1
from (
select id,value,row_number() over(order by id,value desc) rn from table1
)
)
start with rn1 is null
connect by rn1 = prior rn
group by id;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货