WINDOW FUNCTION Functions

All functions > WINDOW FUNCTION

All functions in the WINDOW FUNCTION category.

Numeric

Function	Description
`SUM() OVER ...`	Returns the sum of values in the window frame.
`AVG() OVER ...`	Returns the average of values in the window frame.
`MIN() OVER ...`	Returns the minimum value in the window frame.
`MAX() OVER ...`	Returns the maximum value in the window frame.

Counting

Function	Description
`COUNT() OVER ...`	Returns the count of rows in the window frame.
`COUNT_IF() OVER ...`	Returns the count of rows where the condition is true in the window frame.
`COUNT_DISTINCT() OVER ...`	Returns the count of distinct non-null values in the window frame.
`APPROX_DISTINCT() OVER ...`	Returns the approximate number of distinct values in the window frame.

Boolean

Function	Description
`BOOL_AND() OVER ...`	Returns TRUE if all boolean values in the window frame are true.
`BOOL_OR() OVER ...`	Returns TRUE if any boolean value in the window frame is true.

Numbering

Function	Description
`ROW_NUMBER() OVER ...`	Returns a unique sequential number for each row within its partition, starting at 1.
`RANK() OVER ...`	Returns the rank of the current row within its partition, with gaps. Rows with equal values for the...
`DENSE_RANK() OVER ...`	Returns the rank of the current row within its partition, without gaps. Similar to RANK but...
`NTILE() OVER ...`	Returns the bucket number (1 to n) for each row in a partition, where n is the number of buckets.
`PERCENT_RANK() OVER ...`	Returns the relative rank of the current row: (rank - 1) / (total rows - 1).
`CUME_DIST() OVER ...`	Returns the cumulative distribution: (number of rows <= current row) / (total rows).

Offset

Function	Description
`LEAD() OVER ...`	Returns the value from the row that leads (follows) the current row by a specified offset within...
`LAG() OVER ...`	Returns the value from the row that lags (precedes) the current row by a specified offset within...
`FIRST_VALUE() OVER ...`	Returns the first value in the window frame.
`LAST_VALUE() OVER ...`	Returns the last value in the window frame.
`NTH_VALUE() OVER ...`	Returns the value at the nth row of the window frame.

Collection

Function	Description
`ANY_VALUE() OVER ...`	Returns an arbitrary non-null value from the window frame, if one exists.
`ARRAY_AGG() OVER ...`	Returns an array of all values in the window frame.
`MIN_BY() OVER ...`	Returns the value of the first expression corresponding to the minimum value of the second...
`MAX_BY() OVER ...`	Returns the value of the first expression corresponding to the maximum value of the second...

Statistical

Function	Description
`STDDEV_POP() OVER ...`	Returns the population standard deviation over the window frame.
`STDDEV_SAMP() OVER ...`	Returns the sample standard deviation over the window frame.
`VAR_POP() OVER ...`	Returns the population variance over the window frame.
`VAR_SAMP() OVER ...`	Returns the sample variance over the window frame.
`CORR() OVER ...`	Returns the Pearson correlation coefficient over the window frame.
`COVAR_POP() OVER ...`	Returns the population covariance over the window frame.
`COVAR_SAMP() OVER ...`	Returns the sample covariance over the window frame.
`REGR_SLOPE() OVER ...`	Returns the slope of the linear regression line over the window frame.
`REGR_INTERCEPT() OVER ...`	Returns the y-intercept of the linear regression line over the window frame.
`REGR_R2() OVER ...`	Returns the coefficient of determination (R²) over the window frame.

Summary

Functions in WINDOW FUNCTION: 35

This documentation is automatically generated from the FeatureMesh registry.

Suggest changes to this page

Last update at: 2026/03/03 16:47:38

On this page

Numeric Counting Boolean Numbering Offset Collection Statistical