Eliminate duplicate entries in sql

Question

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

SELECT Item, SUM(Qty), MIN(MinQty), MAX(MaxQty)
FROM tablename
GROUP BY ITem;

Answer 2

The answer above is right, but you would also want to give the derived columns names:

SELECT Item, SUM(Qty) as Qty, MIN(MinQty) as MinQty, MAX(MaxQty) as MaxQty
FROM tablename
GROUP BY ITem;