I have the follwoing table:
is it possible if i want to select data to be like this ?
so, what i need is to group count by caltype and registrationdate(month, year)
any suggestion would be aprreciated thank you :)
Asked
Active
Viewed 38 times
0
Blank
- 12,308
- 1
- 14
- 32
Dwi Teguh Prasetyo
- 179
- 1
- 3
- 15
-
yes it is possible, what query have you tried? – Paul Maxwell May 08 '17 at 05:37
-
This is called 'pivot table', and it's not supported natively by MySQL. Check this thread http://stackoverflow.com/questions/7674786/mysql-pivot-table – Yossi Vainshtein May 08 '17 at 05:38