SELECT *
FROM tb_type
START WITH up_id=29
CONNECT BY PRIOR id=up_id;表
type id up_id
A 29
B 30 29
C 31 30
D 32 30A的id为29,
A下面有节点B,
B下面有节点C和D,
现在我要查询A下面的所有子节点,但要排除有子节点的节点,这里就是要排除B,这个查询语句应该怎样改?
FROM tb_type
START WITH up_id=29
CONNECT BY PRIOR id=up_id;表
type id up_id
A 29
B 30 29
C 31 30
D 32 30A的id为29,
A下面有节点B,
B下面有节点C和D,
现在我要查询A下面的所有子节点,但要排除有子节点的节点,这里就是要排除B,这个查询语句应该怎样改?
FROM f_allguide
where CONNECT_BY_ISLEAF=1//只要叶子节点
START WITH up_id=29
CONNECT BY PRIOR guide_id=up_id