GROUPING_ID
Returns a bitmask corresponding to the grouping of columns.
Analyze Syntax
func.grouping_id(get_column(table, 'a'), get_column(table, 'b'))
Analyze Examples
func.grouping_id(get_column(table, 'department'), get_column(table, 'year'))
┌───┐
│ 0 │
└───┘
SQL Syntax
GROUPING_ID(<a>, <b>)
SQL Examples
SELECT department, year, GROUPING_ID(department, year), SUM(salary)
FROM employees GROUP BY ROLLUP(department, year);
┌───┐
│ 0 │
└───┘