DuckDB 2 · SQL features
Pivot rows into columns
Turn category values into columns.
PIVOT sales ON region USING sum(amount) GROUP BY product;
Official DuckDB 2 documentation
DuckDB 2 · SQL features
Turn category values into columns.
PIVOT sales ON region USING sum(amount) GROUP BY product;
Official DuckDB 2 documentation
Was this page helpful?