# Window Functions

This section contains a list of all window functions in SingleStore, excluding aggregates, which are covered in [Aggregate Functions](https://docs.singlestore.com/db/v9.1/reference/sql-reference/aggregate-functions.md).

For an overview of window functions in SingleStore, see [Window Functions Guide](https://docs.singlestore.com/db/v9.1/developer-resources/functional-extensions/working-with-window-functions.md).

## In this section

* [DENSE\_RANK](https://docs.singlestore.com/db/v9.1/reference/sql-reference/window-functions/dense-rank.md)
* [FIRST\_VALUE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/window-functions/first-value.md)
* [LAG](https://docs.singlestore.com/db/v9.1/reference/sql-reference/window-functions/lag.md)
* [LAST\_VALUE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/window-functions/last-value.md)
* [LEAD](https://docs.singlestore.com/db/v9.1/reference/sql-reference/window-functions/lead.md)
* [NTH\_VALUE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/window-functions/nth-value.md)
* [NTILE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/window-functions/ntile.md)
* [PERCENT\_RANK](https://docs.singlestore.com/db/v9.1/reference/sql-reference/window-functions/percent-rank.md)
* [PERCENTILE\_CONT and MEDIAN](https://docs.singlestore.com/db/v9.1/reference/sql-reference/window-functions/percentile-cont-and-median.md)
* [PERCENTILE\_DISC](https://docs.singlestore.com/db/v9.1/reference/sql-reference/window-functions/percentile-disc.md)
* [RANK](https://docs.singlestore.com/db/v9.1/reference/sql-reference/window-functions/rank.md)
* [ROW\_NUMBER](https://docs.singlestore.com/db/v9.1/reference/sql-reference/window-functions/row-number.md)

***

Modified at: November 17, 2022

Source: [/db/v9.1/reference/sql-reference/window-functions/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/window-functions/)

(An index of the documentation is available at /llms.txt)