GROUPING

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Returns a bit mask indicating which GROUP BY expressions are not included in the current grouping set.

1GROUPING(<group_by_expression> [, ...])

• <group_by_expression>: One or more expressions that must exactly match expressions in the GROUP BY clause.

Returns an integer bit mask. Each bit corresponds to an argument, with the rightmost argument as the least-significant bit. A bit is 0 if the expression is in the grouping set; 1 if it is not.

• Used with grouping sets (ROLLUP, CUBE, GROUPING SETS) to identify which columns were aggregated.
• Maximum of 31 expressions can be used as arguments.
• Arguments are not evaluated but must exactly match GROUP BY expressions.
• Helps distinguish between actual NULL values and NULLs representing aggregated rows.

Identify aggregation levels with ROLLUP.

1SELECT make, model, GROUPING(make, model), sum(sales)
2FROM items_sold
3GROUP BY ROLLUP(make, model);

Returns:

• 0: Both make and model are grouped.
• 1: model is aggregated (not grouped).
• 3: Both make and model are aggregated.

Use GROUPING to filter specific aggregation levels.

1SELECT make, model, sum(sales)
2FROM items_sold
3GROUP BY ROLLUP(make, model)
4HAVING GROUPING(make, model) = 1;

Returns only the subtotals by make (where model is aggregated).

• GROUP BY Clause
• Aggregate Functions