使用层化化查询试试 SELECT [LEVEL] ,column,expression,... FROM table_name [WHERE where_clause] [[START WITH start_condition] [CONNECT BY PRIOR prior_condition]];SQL基础-->层次化查询(START BY ... CONNECT BY PRIOR)
用递归吧 没有好的办法 select * from dual where filter start with col= 根 connect by prior 叶子 = 根
SELECT [LEVEL] ,column,expression,... FROM table_name [WHERE where_clause] [[START WITH start_condition] [CONNECT BY PRIOR prior_condition]];SQL基础-->层次化查询(START BY ... CONNECT BY PRIOR)
select * from dual where filter start with col= 根 connect by prior 叶子 = 根