Hi,
I want to truncate duplicate rows but Qty should be added
I have a table filled with data,
Item Qty MinQty MaxQty
ABC 10 20 50
XYZ 12 30 40
ABC 15 20 50
I want the result like,
Item Qty MinQty MaxQty
ABC 25 20 50
XYZ 12 30 40
Kindly help me to write the query for the same...
Loading
Rosi Sreenivasa ReddyPosted Jul 30, 2013, 9:01 AM