For AI agents: the complete documentation index is at llms.txt. Every page is also available as markdown by appending .md to its URL, or by sending an Accept: text/markdown request header.

ROLLUP keyword

ROLLUP computes hierarchical subtotals in a single query. For example, GROUP BY ROLLUP(symbol, side) returns a row per symbol and side, a subtotal per symbol, and a grand total, which suits reports that drill down from a total to its parts. With N columns, ROLLUP produces N+1 grouping sets. It works with both GROUP BY and SAMPLE BY.

For syntax, examples, and limitations, see ROLLUP on the GROUPING SETS page.