How to transpose mysql table data using mysql query

Question

I would like to transpose attendance sql table as below

To the following

Please help me here

Thanks Sara

So what have you tried? **SO != Free coding resource** – RiggsFolly Oct 01 '16 at 14:48 — RiggsFolly, Oct 01 '16 at 14:48
Thats itself a subquery.. – user1283333 Oct 01 '16 at 16:53 — user1283333, Oct 01 '16 at 16:53

score 1 · Accepted Answer · answered Oct 01 '16 at 14:52

1

In MySQL, you would do this using conditional aggregation:

select pname,
       sum(case when weekday = 'Monday' then days else 0 end) as M,
       . . .,
       sum(days) as Total
from  t
group by pname;

Put the logic in the for the rest of the weekdays where . . . is.

answered Oct 01 '16 at 14:52

Gordon Linoff

Thanks Gordon Linoff, this solved and helped me in time – user1283333 Oct 01 '16 at 16:51

1 Answers1