3 ms·
Building a Pivot Table in SQLite
- jiehong 3y agoAlternatively, with duckdb being able to read directly from an SQLite db, the standard SQL PIVOT can be used: PIVOT products ON year USING sum(income); Ref: https://duckdb.org/docs/sql/statements/pivot.html https://duckdb.org/docs/sql/statements/pivot.html