I am having a table named Purchase, that contains column like
Date, ItemCode, Rate, Qty
03-05-2018 001 10 5
13-05-2018 002 25 15
17-05-2018 001 45 50
25-05-2018 002 55 2
26-05-2018 001 10 25
Each ItemCode has different Rate. I want the output as how much qty is purchased of different amount having same Itemcode
Output like
ItemCode Rate Qty
001 10 30
001 45 50
002 25 15
002 55 2
Please help me with the query
Shahriar NikkhahPosted May 6, 2018, 6:25 PM