【无标题】

最新推荐文章于 2024-10-03 20:14:40 发布

weixin_37905204

最新推荐文章于 2024-10-03 20:14:40 发布

阅读量22

点赞数

文章标签：前端数据库 javascript

本文链接：https://blog.csdn.net/weixin_37905204/article/details/132061177

版权

sql 给树行数据添加序号。

select

substr(sys_connect_by_path(rown.cNO, ‘.’),
2,
length(sys_connect_by_path(rown.cNO, ‘.’))) as wbsNO,
(sys_connect_by_path(rown.cNO, ‘.’)),
rown.*
from (select t.id,
t.name,
t.parent_id,
ROW_NUMBER() OVER(PARTITION BY t.parent_id ORDER BY t.order_number) as cNO
from se_task_plan_template t
) rown
start with rown.parent_id = ‘0’
connect by prior rown.id = rown.parent_id