Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://docs.snowflake.com/en/sql-reference/functions/array_unique_agg below:

Website Navigation

• Reference
• Function and stored procedure reference
• Aggregate

ARRAY_UNIQUE_AGG | Snowflake Documentation

Returns an ARRAY that contains all of the distinct values from the specified column.

See also:

Using Arrays to Compute Distinct Values for Hierarchical Aggregations

ARRAY_UNIQUE_AGG( <column> )

Copy

column

The column containing the values.

The function returns an ARRAY containing the distinct values in the specified column. The values in the ARRAY are in no particular order, and the order is not deterministic.

The function ignores NULL values in column. If column contains only NULL values or the table containing column is empty, the function returns an empty ARRAY.

• This function can be used as either of the following types of functions:

  • aggregate function

  • window function.

• When this function is called as a window function, it does not support explicit window frames.

• This function doesn’t support a structured type as an input argument.

See Using Arrays to Compute Distinct Values for Hierarchical Aggregations.

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4