GROUPING function [Aggregate]

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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Reference » SQL functions » Functions

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.

Returns

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.

See also

Standards and compatibility

Example

Discuter à propos de cette page dans DocCommentXchange.

Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0