An introduction to an optional reference to one or more expressions in the select expression list used to group rows in the result set.
A GROUP BY clause is valid when coded as part of a seed statement.
GROUP BY is never valid when coded as part of a recursive statement.
See Teradata Vantage™ - SQL Data Manipulation Language, B035-1146 for more information.
- ordinary_grouping_set
- A column expression by which the rows returned by the request are grouped.
- empty_grouping_set
- A contiguous LEFT PARENTHESIS, RIGHT PARENTHESIS pair with no argument. In general, this syntax is used to request a grand total.
- rollup_list
- A ROLLUP expression that reports result rows in a single dimension with one or more levels of detail. See Teradata Vantage™ - SQL Data Manipulation Language, B035-1146 for further information.
- cube_list
- A CUBE expression that reports result rows in multiple dimensions with one or more levels of detail. See Teradata Vantage™ - SQL Data Manipulation Language, B035-1146 for further information.
- grouping_sets_specification
- A GROUPING SETS expression that reports result rows in one of two ways:
- As a single dimension, but without a full ROLLUP.
- As multiple dimensions, but without a full CUBE.