Skip to content
Advertisement

Tag: children

How to SUM all subchildren tree in SQL recursively?

Good day, I’ve been pulling my hair on this problem for a while ><” I have 4 categories in a tree structure. tenant_category_transaction_view: I would like to have the sum of all children “sumSubtotal” on every category Something like that: I’ve managed to come very close… But there’s something I don’t get ><” Result of the above query: It seems

Advertisement