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

See https://meta.stackoverflow.com/questions/333952/why-should-i-provide-an-mcve-for-what-seems-to-me-to-be-a-very-simple-sql-query — Strawberry, Apr 19 '17 at 07:16

score 3 · Accepted Answer · answered Apr 19 '17 at 07:12

3

try this:

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

answered Apr 19 '17 at 07:12

Vijunav Vastivch

score 1 · Answer 2 · answered Apr 19 '17 at 07:15

1

You can do something like below

    select coalesce(CAST(id as CHAR(50)),'Total'),
max(local),sum(import),sum(loss),sum(results)  from mytable group by id asc with rollup

answered Apr 19 '17 at 07:15

Rams

2 Answers2