Model Category Color MRP Input_Pairs SY001 Sports Black 100 30 SY004 Sports Red 500 20 SY001 Sports Black 100 10 SY001 Sports Red 800 300
Model Category Color MRP Input_Pairs SY001 Sports Black 200 40 SY004 Sports Red 500 20 SY001 Sports Red 800 300
SELECT Model, Category, Color, SUM(MRP), SUM(Input_Pairs) FROM MyTable GROUP BY Model, Category, Color
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)