select id, sum(quantity). Bonus, Price, sum(total) from table group by id, Bonus, price
select id,sum(quantity) as quantity,Bonus , price,sum(total)as total from table group by id,Bonus , price
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)