(SELECT num,REPLACE(MAX(sql0), ';', ',') FROM (SELECT num, sys_connect_by_path(sql1, ';') AS sql0 FROM (SELECT num, sql1, rn, lead(rn) over(PARTITION BY num ORDER BY rn) rn1 FROM (SELECT num, sql1, row_number() over(ORDER BY num, sql1 DESC) rn FROM tlsbk)) START WITH num = '1' AND rn1 IS NULL CONNECT BY rn1 = PRIOR rn));
用户登录
还没有账号?立即注册
用户注册
投稿取消
文章分类: |
|
还能输入300字
上传中....