By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
beginv | nm | nm1 | qty | qty1 | endinv | seq |
---|---|---|---|---|---|---|
0 | a | ab1 | 5 | 7 | 7 | 1 |
0 | a | ab2 | 15 | 7 | 15 | 2 |
0 | a | ab3 | 11 | 9 | 17 | 3 |
0 | a | ab3 | 11 | 9 | 19 | 4 |
0 | a | ab3 | 11 | 9 | 21 | 5 |
0 | b | ab2 | 10 | 14 | 14 | 1 |
0 | b | ab3 | 11 | 9 | 16 | 2 |
0 | c | ab1 | 11 | 9 | 9 | 1 |
0 | c | ab2 | 15 | 9 | 15 | 2 |
0 | c | ab3 | 15 | 9 | 21 | 3 |