![GRAPHICAL_PLAN function [String]](arrow-left.gif){kind=icon}
![GROUP_MEMBER function [System]](arrow-right.gif){kind=icon}
Identifies whether a column in a ROLLUP or CUBE operation result set is NULL because it is part of a subtotal row, or NULL because of the underlying data.
GROUPING ( group-by-expression )
group-by-expression An expression appearing as a grouping column in the result set of a query that uses a GROUP BY clause with the ROLLUP or CUBE keyword. The function identifies subtotal rows added to the result set by a ROLLUP or CUBE operation.
Currently, Sybase IQ does not support the PERCENTILE_CONT or PERCENTILE_DISC functions with GROUP BY CUBE operations.
1 Indicates that group-by-expression is NULL because it is part of a subtotal row. The column is not a prefix column for that row.
0 Indicates that group-by-expression is a prefix column of a subtotal row.
SELECT statement in Reference: Statements and Options
Chapter 2, “Using OLAP” in the System Administration Guide: Volume 2
