Remove duplicate entry

Question

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...