By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
11 rows affected
orgId | tree_order | path | cnt |
---|---|---|---|
100 | 0 | 100/ | 9 |
1000 | 0 | 1000/ | 2 |
2000 | 1 | 1000/2000/ | 1 |
129 | 1 | 100/129/ | 5 |
134 | 1 | 100/134/ | 3 |
133 | 2 | 100/134/133/ | 2 |
133 | 2 | 100/134/133/ | 2 |
439 | 2 | 100/129/439/ | 3 |
450 | 2 | 100/129/450/ | 1 |
501 | 3 | 100/129/439/501/ | 2 |
602 | 4 | 100/129/439/501/602/ | 1 |