Skip to Content
0
Aug 18, 2023 at 10:57 AM

Hna cloud sql query to sum the data based on levels and partitioning by parentnode

253 Views Last edit Aug 21, 2023 at 01:00 AM 2 rev

id level description netprice Parentnode hirerachynode

100 0 Total sum(offering1+offering2) Null 1000

100 1 offering1 sum(service1+service2) 1000 11

100 1 offering2 sum(service3+service4) 1000 12

100 2 service1 sum(deilvery1+delivery2) 11 40

100 2 service2 sum(deilvery3+delivery4) 11 41

100 2 service3 sum(deilvery5+delivery6) 12 42

100 2 service4 sum(deilvery7+delivery8) 12 43

100 3 delivery1 110 40

100 3 delivery2 120 40

100 3 delivery3 130 41

100 3 delivery4 140 41

100 3 delivery5 - 150 42

100 3 delivery6 160 42

100 3 delivery7 170 43

100 3 delivery8 180 43

I have this data and i need to achieve the above summing for level 0,1,and 2 please let me know how to write a query to achieve this requirement