SELECT id, SUM(quantity) FROM tablename GROUP BY id
Select id,sum(quantity) from table group by id
select id, sum(quantity) from yourtable group by id
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)