Tag:PivotTable report

  • Sample code of how MySQL / MariaDB implements PivotTable report

    Time:2021-10-17

    The previous article introduced several methods to implement PivotTable in Oracle. Today, let’s see how to implement the same functions in MySQL / MariaDB. The sample data used in this article can be downloaded here. Use case expressions and group aggregation The essence of PivotTable report is to group data according to different combinations of […]