Need query for this Output

Feb 28 2017 5:41 AM

Hello,

I have a table named "Shipment":

carton_no itemno location_code quantity

AD/00005/ER FLOWER2 BLOCK 4 6

AD/00007/ER FLOWER2 BLOCK 4 1

AD/00003/ER FLOWER BLOCK 4 4

AD/00004/ER FLOWER BLOCK 4 4

AD/00005/ER FLOWER BLOCK 4 4

AD/00003/ER FLOWER2 BLOCK 4 6

AD/00003/ER FLOWER BLOCK2 3

AD/00005/ER FLOWER BLOCK 4 4

I need output:

carton_no itemno location_code quantity

AD/00003/ER FLOWER BLOCK 4 7

AD/00003/ER FLOWER2 BLOCK 4 6

AD/00004/ER FLOWER BLOCK 4 4

AD/00005/ER FLOWER BLOCK 4 8

AD/00005/ER FLOWER2 BLOCK 4 6

AD/00007/ER FLOWER2 BLOCK 4 1

Thanks in Advance

Answers (17)

Get Credit number