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

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

VARIANCE_POP | Snowflake Documentation

Categories:

Aggregate functions (General) , Window function syntax and usage (General)

Returns the population variance of non-NULL records in a group. If all records inside a group are NULL, a NULL is returned.

Aliases:

VAR_POP

Aggregate function

VARIANCE_POP( [ DISTINCT ] <expr1> )

Copy

Window function

VARIANCE_POP( [ DISTINCT ] <expr1> ) OVER (
                                          [ PARTITION BY <expr2> ]
                                          [ ORDER BY <expr3> [ ASC | DESC ] [ <window_frame> ] ]
                                          )

Copy

For detailed window_frame syntax, see Window function syntax and usage.

expr1

The expr1 should evaluate to one of the numeric data types.

expr2

This is the optional expression to partition by.

expr3

This is the optional expression to order by within each partition.

The data type of the returned value is NUMBER(<precision>, <scale>). The scale depends upon the values being processed.

• When passed a VARCHAR expression, this function implicitly casts the input to floating point values. If the cast cannot be performed, an error is returned.

• When this function is called as a window function with an OVER clause that contains an ORDER BY clause:

  • A window frame is required. If no window frame is specified explicitly, the following implied window frame is used:

    RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW

    For more information about window frames, including syntax, usage notes, and examples, see Window function syntax and usage.

  • Using the keyword DISTINCT inside the window function is prohibited and results in a compile-time error.

For examples, see VAR_POP.

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