chethana mn

chethana mn

  • NA
  • 15
  • 9.8k

Remove duplicate entry in sql query

Jul 30 2013 8:56 AM
Hi,
 
I want to truncate duplicate rows but Qty should be added
 
I have a table filled with data,
 

Item Qty MinQty MaxQty
ABC10 20 50
XYZ 12 30 40
ABC 15 20 50
 
I want the result like,
Item Qty MinQty MaxQty
ABC25 20 50
XYZ 12 30 40
 
Kindly help me to write the query for the same...

Answers (8)