By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| ID | RevID | Designation | ParentID | Amount |
|---|---|---|---|---|
| 100 | 500 | Test1 | 300 | 5000 |
| 250 | 500 | Test2 | 360 | 5000 |
| 410 | 500 | Test3 | 580 | 5000 |
| 800 | 400 | Test400 | 360 | 8000 |
| 100 | 400 | Test1 | 300 | 9000 |
| 100 | 500 | Test1 | 300 | 6500 |