汉高pgsql以及金仓数据库通用sql递归

呀喳喳小红帽

于 2019-12-25 19:20:14 发布

阅读量554

点赞数

分类专栏： postgreatsql

本文链接：https://blog.csdn.net/weixin_44594257/article/details/103492590

版权

postgreatsql 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

–向下递归 postgresql
with recursive T (“dept_id”, “parent_id”, “name”) AS
(
select “dept_id”, “parent_id”, “name” from “sys_dept” where sys_dept.“dept_id”=‘282’ --起始节点
union all
select D.“dept_id”, D.“parent_id”, D.“name” from “sys_dept” D join T on D.“parent_id” = T.“dept_id”
)
select “dept_id”, “parent_id”, “name” from T

–向上递归
with recursive T (“dept_id”, “parent_id”, “name”) AS
(
select “dept_id”, “parent_id”, “name” from “sys_dept” where “dept_id”=‘282’ --起始节点
union all
select D.“dept_id”, D.“parent_id”, D.“name” from “sys_dept” D join T on D.“dept_id” = T.“parent_id”
)
select “dept_id”, “parent_id”, “name” from T