`grouping` function

Applies to: check marked yes Databricks SQL Databricks Runtime

Indicates whether a specified column in a GROUPING SET, ROLLUP, or CUBE represents a subtotal.

Syntax

grouping(col)

Arguments

col: A column reference identified in a GROUPING SET, ROLLUP, or CUBE.

Returns

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.

Examples

> 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