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.
- To reference a column that has a LOB data type, do one of the following:
- Cast the LOB to a non-LOB type (for example, cast BLOB to BYTE or VARBYTE, cast CLOB to CHARACTER or VARCHAR)
- Pass the LOB to a function whose result is not a LOB.