Eliminate duplicate entries in sql

sql

Solution

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

Problem

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

Original source