wish your support to rotate the table without the function PIVOT
this is the result.
it is only separated by 1,2,3,4 with if value by id
Asked
Active
Viewed 23 times
0
-
Why should PIVOT not be used? – Jonas Metzler Oct 31 '22 at 13:25
-
1@JonasMetzler Maybe because PIVOT not exists in MySQL? – Akina Oct 31 '22 at 13:28
-
If `califica` values list is static 1..4 then use conditional aggregation. – Akina Oct 31 '22 at 13:29
-
it is right doesn't exist in MySQL, Yes califica is the value 1,2,3,4 – informatica Oct 31 '22 at 13:34
-
See also `GROUP_CONCAT()`. – Rick James Oct 31 '22 at 19:19