pgsql模拟oracle的start with connect by查询

最新推荐文章于 2024-04-08 11:31:15 发布

GastonPeng

最新推荐文章于 2024-04-08 11:31:15 发布

阅读量2.6k

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/qq_36421955/article/details/106387368

版权

数据库专栏收录该内容

26 篇文章 3 订阅

订阅专栏

with t as (select * from t_department where parent_id=0) select count(0) from t;  

with t1 as (select * from t_department),t2 as(select * from t_department where parent_id=0) 
select t1.* from t1,t2 where t2.id=t1.parent_id;


with recursive t as(select id,name,parent_id from t_department where id=1 union all select k.id,k.name,k.parent_id from t_department k,t where t.id=k.parent_id) select * from t;