Skip to main content
Returns an array containing distinct, non-null values in a column or group. Optionally supports sorting direction. Category: aggregate Syntax:
Returns: ArrayColumn Context Filtering: ✗ No

​
Parameters

​
Validation

  • Minimum parameters: 1
  • Maximum parameters: 2

​
Examples

Returns distinct Product Type values ordered ascending as an array.
Last modified on March 13, 2026