dynamic query to column to row in mysql

Question

I have following table:

and I want:

It is not about pivot table. I want a select query to get the desired query.

I want to make view from the query result.

Please help me.

People are not going to help you if you don't show some effort. Write a proper question, include your code in the question and then explain what you have done so far. — Styphon, Oct 08 '15 at 10:46
have a look at the `GROUP BY` part of a `SELECT` statement. Overall, you seem to have invested almost no work in researching. That is bad. — Joshua, Oct 08 '15 at 10:46
Duplicate of http://stackoverflow.com/questions/7674786/mysql-pivot-table — Barmar, Oct 08 '15 at 10:48

score 0 · Accepted Answer · edited May 23 '17 at 12:29

0

Solution for your problem is to use PIVOT

edited May 23 '17 at 12:29

Community

answered Oct 08 '15 at 10:56

japzdivino

Can you please provide me it in Mysql – abhinawbharat04 Oct 08 '15 at 10:59
@abhinawbharat04 , link in above answer has a solution, you need to do some effort to read and study, i am not going to do your home work. – japzdivino Oct 08 '15 at 11:01
What if I want to do it without prepare? – abhinawbharat04 Oct 09 '15 at 10:52
Actually I want to make view from the query result. – abhinawbharat04 Oct 09 '15 at 10:55

1 Answers1