How to create a matrix out of two columns?
-
tarancepil7
- Posts: 1
- Joined: Fri 08 May 2020 05:39
How to create a matrix out of two columns?
I have one table with student registrations containing the student's school name and class. I would like to "explode" this data into a matrix with one row per school and as many columns as there are classes (10). Is this possible with MySQL, or do I need to make a query grouped by classes for each school?
-
alexa
Re: How to create a matrix out of two columns?
We recommend you to refer to some dedicated SQL forums on this as we provide technical support only on dbForge products.