By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
25 rows affected
| Material_Desc | Movement_type | Prev_Movement_type | GroupID |
|---|---|---|---|
| xx1 | 13 | null | 1 |
| xx8 | 14 | 13 | 1 |
| xx2 | 16 | 14 | 2 |
| xx4 | 15 | 16 | 2 |
| xx5 | 15 | 15 | 2 |
| xx6 | 15 | 15 | 2 |
| xx1 | 15 | 15 | 2 |
| xx7 | 15 | 15 | 2 |
| xx7 | 15 | 15 | 2 |
| xx8 | 15 | 15 | 2 |
| xx1 | 13 | 15 | 3 |
| xx11 | 14 | 13 | 3 |
| xx12 | 13 | 14 | 4 |
| xx13 | 14 | 13 | 4 |
| xx15 | 14 | 14 | 4 |
| xx4 | 13 | 14 | 5 |
| xx3 | 14 | 13 | 5 |
| xx2 | 14 | 14 | 5 |
| xx1 | 16 | 14 | 6 |
| xx2 | 15 | 16 | 6 |
| xx3 | 15 | 15 | 6 |
| xx1 | 15 | 15 | 6 |
| xx2 | 15 | 15 | 6 |
| xx1 | 15 | 15 | 6 |
| xx2 | 16 | 15 | 7 |