DuckDB 2 · SQL features
Group by all non-aggregated columns
Skip listing the grouping columns by hand.
SELECT region, product, sum(amount) AS total FROM sales GROUP BY ALL;
Official DuckDB 2 documentation
DuckDB 2 · SQL features
Skip listing the grouping columns by hand.
SELECT region, product, sum(amount) AS total FROM sales GROUP BY ALL;
Official DuckDB 2 documentation
Was this page helpful?