> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Grouping Functions

<a id="sql-grouping-functions" />

These functions can be applied to [group](/content/sql/query/grouping#sql-grouping) data.

<AccordionGroup>
  <Accordion title="ROLLUP(expr)" id="rollup-expr" defaultOpen>
    Calculates *n* + 1 aggregates for *n* number of columns in `expr`
  </Accordion>

  <Accordion title="CUBE(expr)" id="cube-expr" defaultOpen>
    Calculates 2<sup>n</sup> aggregates for *n* number of columns in `expr`
  </Accordion>

  <Accordion title="GROUPING SETS(expr)" id="grouping-sets-expr" defaultOpen>
    Calculates aggregates for any given aggregates in `expr`, including `ROLLUP()` and
    `CUBE()`
  </Accordion>
</AccordionGroup>