GROUP BY Clause - Teradata Database - Teradata Vantage NewSQL Engine

SQL Data Manipulation Language

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
fbo1512081269404.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata Vantage™

Purpose

Groups result rows by the values in one or more columns or by extended GROUP BY operations on specified column expressions.

For information about the GROUP BY TIME clause, see Teradata Vantage™ Time Series Tables and Operations, B035-1208.

Syntax



Syntax Elements

GROUP BY
Reference to one or more expressions in the select expression list.
ordinary_grouping_set
Column expression by which the rows returned by the statement are grouped.
You cannot specify BLOB, CLOB, Period, ARRAY, VARRAY, XML, or JSON columns in the grouping expression.
ordinary_grouping_set can include:
  • column_name
  • column_position
  • column_expression
For the definitions of these expressions, see Ordinary Grouping Set Expressions.
empty_grouping_set
Contiguous LEFT PARENTHESIS, RIGHT PARENTHESIS pair without an argument. You use this syntax to request a grand total, that is, a summation of all the individual group totals, not a summation of the nonaggregate data.
The term grand total refers to .
rollup_list
ROLLUP expression that reports result rows in a single dimension with one or more levels of detail. For more information, see ROLLUP Grouping Set Option.
The expression cannot group result rows that have a BLOB, CLOB, ARRAY, or VARRAY type.
cube_list
A CUBE expression that reports result rows in multiple dimensions with one or more levels of detail. For more information, see CUBE Grouping Set Option.
The expression cannot group result rows that have a BLOB, CLOB, ARRAY, or VARRAY type.
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.
For more information, see GROUPING SETS Option.

ANSI Compliance

The GROUP BY clause is ANSI SQL:2011-compliant with extensions.