add batch remove batch split batch show hidden batches hide batch
db<>fiddle
feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
14 rows affected
PartNumber PartValue Parts NewUniqueNumber
P2 1 1,2 1
P2 2 1,2 1
P5 1 1,2 1
P5 2 1,2 1
P3 1 1,2,3 2
P3 2 1,2,3 2
P3 3 1,2,3 2
P4 1 1,2,3 2
P4 2 1,2,3 2
P4 3 1,2,3 2
P1 1 1,2,3,4 3
P1 2 1,2,3,4 3
P1 3 1,2,3,4 3
P1 4 1,2,3,4 3
PartNumber PartValue CNT UniqNo
P2 1 2 1
P2 2 2 1
P5 1 2 1
P5 2 2 1
P3 1 3 2
P3 2 3 2
P3 3 3 2
P4 1 3 2
P4 2 3 2
P4 3 3 2
P1 1 4 3
P1 2 4 3
P1 3 4 3
P1 4 4 3