ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

GROUPING function [Aggregate]

Function 

Identifies whether a column in a ROLLUP 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 keyword. The function identifies subtotal rows added to the result set by a ROLLUP operation.

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 

• SQL/92    Vendor extension.

• SQL/99    SQL/foundation feature outside of core SQL.

• Sybase    Not supported by Adaptive Server Enterprise.

See also 

The ROLLUP operation: adding summary information to GROUP BY queries

SELECT statement

Example 

See The ROLLUP operation: adding summary information to GROUP BY queries.