Get started
Load & manage data
Work with data
Administration
Reference & resources
CLUSTER BY
mask
ROW FILTER
Updated Oct 11, 2024
Send us feedback
grouping
Applies to: Databricks SQL Databricks Runtime
Indicates whether a specified column in a GROUPING SET, ROLLUP, or CUBE represents a subtotal.
GROUPING SET
ROLLUP
CUBE
grouping(col)
col: A column reference identified in a GROUPING SET, ROLLUP, or CUBE.
col
An INTEGER.
The result is 1 for a specified row if the row represents a subtotal over the grouping of col, or 0 if it is not.
> SELECT name, grouping(name), sum(age) FROM VALUES (2, 'Alice'), (5, 'Bob') people(age, name) GROUP BY cube(name); Alice 0 2 Bob 0 5 NULL 1 7
grouping_id function