GROUP BY Clause Terminology - Teradata VantageCloud Lake

Lake - Working with SQL

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jbe1714339405530.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
jbe1714339405530
A simple GROUP BY clause does not contain any of the following elements:
  • rollup_list
  • cube_list
  • grouping_sets_specification
A primitive GROUP BY clause does not contain any of the following elements:
  • rollup_list
  • cube_list
  • grouping_sets_specification
  • grouping_expression and empty_grouping_set

See GROUPING SETS Option for definitions of rollup_list, cube_list, grouping_sets_specification, and empty_grouping_set.

See the following topics for examples of non-simple, non-primitive GROUP BY clauses: