表t有两个字段id和pid,内容如下:
id pid
-----------
1 0
2 1
3 0现在列出1的所有子孙节点,我用
select * from t
start with id=1
connect by prior id = pid;查询出来的结果却是:
id pid
-------------
1 0请问这个sql语句错在什么地方了呢?为什么没有延顺到2这个节点呢?
id pid
-----------
1 0
2 1
3 0现在列出1的所有子孙节点,我用
select * from t
start with id=1
connect by prior id = pid;查询出来的结果却是:
id pid
-------------
1 0请问这个sql语句错在什么地方了呢?为什么没有延顺到2这个节点呢?
as
(
select 1 a,0 b from dual
union all
select 2,1 from dual
union all
select 3,0 from dual
)
select * from temp
start with a=1
connect by prior a = b
--result:1 0
2 1