GoogleSQL for BigQuery supports the following window functions.
Function list
| Name | Summary |
|---|---|
CUME_DIST | Gets the cumulative distribution (relative position (0,1]) of each row within a window. For more information, see Numbering functions. |
DENSE_RANK | Gets the dense rank (1-based, no gaps) of each row within a window. For more information, see Numbering functions. |
FIRST_VALUE | Gets a value for the first row in the current window frame. For more information, see Navigation functions. |
LAG | Gets a value for a preceding row. For more information, see Navigation functions. |
LAST_VALUE | Gets a value for the last row in the current window frame. For more information, see Navigation functions. |
LEAD | Gets a value for a subsequent row. For more information, see Navigation functions. |
NTH_VALUE | Gets a value for the Nth row of the current window frame. For more information, see Navigation functions. |
NTILE | Gets the quantile bucket number (1-based) of each row within a window. For more information, see Numbering functions. |
PERCENT_RANK | Gets the percentile rank (from 0 to 1) of each row within a window. For more information, see Numbering functions. |
PERCENTILE_CONT | Computes the specified percentile for a value, using linear interpolation. For more information, see Navigation functions. |
PERCENTILE_DISC | Computes the specified percentile for a discrete value. For more information, see Navigation functions. |
RANK | Gets the rank (1-based) of each row within a window. For more information, see Numbering functions. |
ROW_NUMBER | Gets the sequential row number (1-based) of each row within a window. For more information, see Numbering functions. |
ST_CLUSTERDBSCAN | Performs DBSCAN clustering on a group of GEOGRAPHY values and produces a 0-based cluster number for this row. For more information, see Geography functions. |