SELECT DISTINCT a.AUT_STATNEW
FROM R5AUTH a
where AUT_ENTITY='E'
START WITH a.AUT_STATUS ='A'
CONNECT BY a.AUT_STATUS = PRIOR a.AUT_STATNEW 取根和叶子各该怎么加呢
类似于这样的语句我该加到什么地方
SELECT DISTINCT a.AUT_STATNEW
FROM R5AUTH a
where AUT_ENTITY='E'
START WITH a.AUT_STATUS ='A'
CONNECT BY a.AUT_STATUS = PRIOR a.AUT_STATNEW