GoogleSQL for BigQuery supports the following
[window functions](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/window-function-calls).

## Function list

| Name | Summary |
|---|---|
| [`CUME_DIST`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/numbering_functions#cume_dist) | Gets the cumulative distribution (relative position (0,1\]) of each row within a window. For more information, see [Numbering functions](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/numbering_functions). |
| [`DENSE_RANK`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/numbering_functions#dense_rank) | Gets the dense rank (1-based, no gaps) of each row within a window. For more information, see [Numbering functions](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/numbering_functions). |
| [`FIRST_VALUE`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions#first_value) | Gets a value for the first row in the current window frame. For more information, see [Navigation functions](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions). |
| [`LAG`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions#lag) | Gets a value for a preceding row. For more information, see [Navigation functions](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions). |
| [`LAST_VALUE`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions#last_value) | Gets a value for the last row in the current window frame. For more information, see [Navigation functions](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions). |
| [`LEAD`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions#lead) | Gets a value for a subsequent row. For more information, see [Navigation functions](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions). |
| [`NTH_VALUE`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions#nth_value) | Gets a value for the Nth row of the current window frame. For more information, see [Navigation functions](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions). |
| [`NTILE`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/numbering_functions#ntile) | Gets the quantile bucket number (1-based) of each row within a window. For more information, see [Numbering functions](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/numbering_functions). |
| [`PERCENT_RANK`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/numbering_functions#percent_rank) | Gets the percentile rank (from 0 to 1) of each row within a window. For more information, see [Numbering functions](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/numbering_functions). |
| [`PERCENTILE_CONT`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions#percentile_cont) | Computes the specified percentile for a value, using linear interpolation. For more information, see [Navigation functions](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions). |
| [`PERCENTILE_DISC`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions#percentile_disc) | Computes the specified percentile for a discrete value. For more information, see [Navigation functions](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions). |
| [`RANK`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/numbering_functions#rank) | Gets the rank (1-based) of each row within a window. For more information, see [Numbering functions](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/numbering_functions). |
| [`ROW_NUMBER`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/numbering_functions#row_number) | Gets the sequential row number (1-based) of each row within a window. For more information, see [Numbering functions](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/numbering_functions). |
| [`ST_CLUSTERDBSCAN`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_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](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions). |