mysql select * from table group by id with rollup

Question

I try to select from my table and rollup to get the Total but i failed. Here is my table and values

and the result i want like this

is this possible? my query :

select * from mytable group by id with rollup;

But my query failed to get the rollup values, please show me the way thanks

Answer 1

try this:

select id,sum(qty),sum(import),sum(loss),sum(results) 
from mytable group by id asc with rollup;