Skip to main content

DISTINCT

Return one row per distinct combination of the given expressions.

Syntax​

DISTINCT groupClause (, groupClause)* [,]?

Parameters​

  • groupClause - Field, expression, or name = expression.

Description​

The pipeline keeps one row per unique combination of the given expressions. The output schema is the keys you list; other input fields are not carried through.

  • AGG — Grouping with aggregation functions