Oracle 树操作

最新推荐文章于 2024-09-26 21:04:50 发布

pliuxibk

最新推荐文章于 2024-09-26 21:04:50 发布

阅读量89

点赞数

分类专栏：数据库文章标签： sql

本文链接：https://blog.csdn.net/pliuxibk/article/details/110623783

版权

数据库专栏收录该内容

3 篇文章 0 订阅

订阅专栏

with tmp as( select tb_menu.*, level lev from tb_menu start with parent is null connect by parent = prior id)

  SELECT     pid, LTRIM (MAX (SYS_CONNECT_BY_PATH (by_path, ',')), ',')       FROM (SELECT   pid,                      ROW_NUMBER () OVER (PARTITION BY pid ORDER BY pid)                                                                         by_pid,                       ROW_NUMBER () OVER (ORDER BY pid) + pid AS rn,                       NAME AS by_path                  FROM test1              ORDER BY 1)  START WITH by_pid = 1CONNECT BY rn - 1 = PRIOR rn   GROUP BY pid      ORDER BY =1