oracle递归分组,关于递归查询的分组统计问题.pdfVIP

oracle递归分组,关于递归查询的分组统计问题

是要累加对吧，⽐如id=1下⾯包含所有的⼦节点和⾃⾝统计，也就是统计每个⼦树和，根不要就⽤WHERECONNECT_BY_ISLEAF=1过

滤

SQLSELECTid,p_id,value,

2(SELECTSUM(value)FROM

3test_treea

4STARTWITHa.id=b.id

5CONNECTBYPRIORa.id=a.p_id

6)sum_sal

7FROM

8test_treeb;

IDP_IDVALUESUM_SAL

10336

21623

31510

4222

5277

6288

7355

7rowsselected

SQL

SQLSELECTroot_id,SUM(value)

2FROM(selectCONNECT_BY_ROOTa.idroot_id,p_id,value

3fromtest_treea

4CONNECTBYPRIORid=a.p_id

5)

6GROUPBYroot_id;

ROOT_IDSUM(VALUE)

136

223

310

42

57

68

75

7rowsselected