By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
10 rows affected
PartNum | a | AM01 | AM02 | AM03 | AM04 | AM05 | AM06 | AM07 | AM08 | AM09 | AM10 | AM11 | AM12 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
aa | 4 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
aa | 4 | 2 | 4 | 6 | 8 | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24 |
aa | 5 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
aa | 5 | 2 | 4 | 6 | 8 | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24 |
aa | 5 | 3 | 6 | 9 | 12 | 15 | 18 | 21 | 24 | 27 | 30 | 33 | 36 |
bb | 4 | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100 | 110 | 120 |
bb | 4 | 20 | 40 | 60 | 80 | 100 | 120 | 140 | 160 | 180 | 200 | 220 | 240 |
bb | 5 | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100 | 110 | 120 |
bb | 5 | 20 | 40 | 60 | 80 | 100 | 120 | 140 | 160 | 180 | 200 | 220 | 240 |
bb | 5 | 30 | 60 | 90 | 120 | 150 | 180 | 210 | 240 | 270 | 300 | 330 | 360 |
PartNum | a | Total_In |
---|---|---|
aa | 4 | 30 |
bb | 4 | 300 |
PartNum | a | Total_Out |
---|---|---|
aa | 5 | 60 |
bb | 5 | 600 |
PartNum | Total_In | Total_Out |
---|---|---|
aa | 30 | 60 |
bb | 300 | 600 |