oracle找出 当前节点的最高祖先

[Miracle_lucy]

oracle如何找出 当前节点的最高祖先

[Miracle_lucy]

引用 4 楼 z123zjf 的回复:

PRIOR DEP_ID = SUPER_ID

这个找出来是最近祖父呢

[陈灬风]

SYS_CONNECT_BY_PATH函数?

[Miracle_lucy]

[Miracle_lucy]

SELECT CONNECT_BY_ROOT DEP_ID AS ROOTID,
       DEP_ID,
       DEP_NAME        AS NAME,
       SUPER_ID        AS PID,
       FOLDER,
       LEVEL
  FROM TD_DEPARTMENT
 WHERE DEP_ID != 1
CONNECT BY DEP_ID = PRIOR SUPER_ID
 START WITH DEP_ID = '471'
 ORDER BY LEVEL DESC

想得到的数据，rootid都应该是71的，应该怎么改？

[z123zjf]

PRIOR DEP_ID = SUPER_ID

[Miracle_lucy]