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.