How to generate such a table

Asked Oct 13 '17 at 06:23

Active Oct 13 '17 at 06:26

Viewed 25 times

Saying that I have a table as below:

year    month    price
1991      1       1.1
1991      2       1.2
1991      3       1.3
1992      1       2.1
1992      2       2.2
1992      3       2.3

Now I want to generate such a table according to the table above:

year    m1    m2    m3
1991    1.1   1.2   1.3
1992    2.1   2.2   2.3

How to do this with SQL?

edited Oct 13 '17 at 06:26

Uwe Keim

38,279
56
171
280

asked Oct 13 '17 at 06:23

Yves

10,315
11
69
141

What version of SQL are you using (e.g. MySQL, Oracle, SQL Server, etc.) ? – Tim Biegeleisen Oct 13 '17 at 06:25
@TimBiegeleisen Sorry, it's MySQL – Yves Oct 13 '17 at 06:26
I wouldn't. Instead I'd handle issues of data display in application code – Strawberry Oct 13 '17 at 06:28
I have been warned not to answer any more pivot query MySQL questions. If you spend just a few minutes Googling or searching SO you will find tons of examples for how to do this.. – Tim Biegeleisen Oct 13 '17 at 06:28
@TimBiegeleisen Thanks man, pivot query, never heard this before... lol – Yves Oct 13 '17 at 06:30
@Yves If you really get stuck somewhere, then come back and edit your question. My guess, given your rep level, is that you won't get stuck :-) – Tim Biegeleisen Oct 13 '17 at 06:30

How to generate such a table

0 Answers0