Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » SQL Functions » Alphabetical list of functions

GREATER function [Miscellaneous] Next Page

GROUPING function [Aggregate]


Identifies whether a column in a GROUP BY 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. This function can be used to identify subtotal rows added to the result set by a ROLLUP or CUBE operation.

Return value
See also
Standards and compatibility
Example

For examples of this function in use, see Detecting placeholder NULLs using the GROUPING function.