数据如
表名: table1
id pid aid
4225701 4225664
4225664 4225486
4225486 201404266649
现在有 table1 Id 4225701
需要找到 4225486 对应的 aid (201404266649)
------解决方案--------------------
SELECT AID
FROM TEST T
WHERE CONNECT_BY_ISLEAF = 1
START WITH T.ID = '4225701'
CONNECT BY PRIOR PID = ID