If by a parent node, or intermediate node, query the last level of all child nodes,
As long as the final stage,

CodePudding user response:

Select * from table_test
Where CONNECT_BY_ISLEAF=1
Start with parentid=1
Connect by the prior id=parentid