Help Center/ Data Lake Insight/ SQL Syntax Reference (Ally Region)/ Flink OpenSource SQL 1.15 Syntax Reference/ Functions/ Built-In Functions/ Grouping Functions
Updated on 2026-01-09 GMT+08:00
View PDF
Share

Grouping Functions

Table 1 Grouping functions

SQL Function

Description

GROUP_ID()

Returns an integer that uniquely identifies the combination of grouping keys.

GROUPING(expression1 [, expression2]* ) | GROUPING_ID(expression1 [, expression2]* )

Returns a bit vector for the given grouping expression.
Parent Topic: Built-In Functions