GROUPING function [Aggregate]

Function

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.

Syntax

GROUPING ( group-by-expression )

Parameters

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.

Return value

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.

Standards and compatibility

SQL92 Vendor extension.

SQL99 SQL/foundation feature outside of core SQL.

Sybase Not supported by Adaptive Server Enterprise.