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

Answer 1

I Have been considering the problem with editing text and drawing editable graphics to an Image. I believe the approach I am going to take is to implement a layer drawing system, I just need to work out the transparency implementation, I know transparancy doesn't truly exist, even at the system level. but I believe it can be faked well. then I know I can save my layered image as a composite. Does this all sound like a good approach??? please any help???