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

SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
vjt1596846980081.ditamap
dita:ditavalPath
vjt1596846980081.ditaval
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata Vantageā„¢
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.