如何将叶子节点的数据合计到父节点 by Oracle 10g

Question

如题所述

Answer 1

如何将叶子节点的数据合计到父节点 by Oracle 10g
with tmp as (
select 1 as id , null as parentid , '成本' as name , null as amount from dual union all
select 2,1 , '工资', null from dual union all
select 3,2 , '基本工资', 1000 from dual union all
select 4,2 , '奖金' , 200 from dual union all
select 5,1 , '保险' , 400 from dual
)
select * from tmp