ROLLUP Option Syntax | SQL SELECT Statements | Teradata Vantage - 17.05 - ROLLUP Option Syntax - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1146-175K
Language
English (United States)
ROLLUP { ordinary_grouping_set | ( ordinary_grouping_set [,...] ) }

Syntax Elements

ordinary_grouping_set
One or more expressions used to group rolled up report rows across a single dimension.
The expression cannot group result rows that have a BLOB, CLOB, ARRAY, or VARRAY type.
All ordinary grouping sets must make explicit column references. You cannot specify column positions with ROLLUP.
Rolling up over a single column is equivalent to a simple GROUP BY on that same column.
You cannot specify more than 190 columns in the ordinary grouping sets.
You cannot reference columns that have a LOB data type unless they are first CAST to another data type or passed to a function whose result is not a LOB. For example, casting a BLOB to BYTE or VARBYTE or casting a CLOB to CHARACTER or VARCHAR.