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 . |
