How to build a pivot table in SQLite saaj edited this page on Aug 6, 2021 · 1 revision Static-column pivot table Dynamic-column pivot table This how-to explores how to build pivot tables in SQLite, ...

This how-to explores how to build pivot tables in SQLite, which doesn't have a special constructs like PIVOT or CROSSTAB in its SQL dialect. If the columns of a pivot table are known beforehand, it's ...