ROLLUP Option Syntax | SQL SELECT Statements | Teradata Vantage - ROLLUP Option Syntax - Analytics Database - Teradata Vantage

SQL Data Manipulation Language

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-12-13
dita:mapPath
pon1628111750298.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
esx1472246586715
lifecycle
latest
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.