说明:查询LIABILITY
父节点下的所有子节点数据(包含孙子节点等)
select distinct t1.coa_node_name
from coa_node t1
where T1.partition_key = '202107310015'
and T1.coa_node_type_code = 'Account'
start with t1.coa_node_name = 'LIABILITY'
connect by prior t1.coa_node_name = t1.coa_parent_node_name
部分表结果及关键数据如下