Indicates whether a specified column expression in a GROUP BY list is aggregated or not. GROUPING returns 1 for aggregated or 0 for not aggregated in the result set. GROUPING can be used only in the SELECT <select> list, HAVING, and ORDER BY clauses when GROUP BY is specified.
Syntax
GROUPING ( <column_expression> )
Arguments
Is a column or an expression that contains a column in a GROUP BY clause.
Return types
tinyint
Examples
SELECT GROUPING([Id]) AS [Grouping] FROM [BasicDataTable] GROUP BY [Id] WITH ROLLUP