# Window functions

[Read this page in HTML](https://www.scopedb.io/docs/reference/functions/window)

Window functions use related rows to calculate a result for each input row, such as comparing consecutive events within a session. Use them in a [`WINDOW` clause](https://www.scopedb.io/docs/reference/commands/stmt-query.md#window).

## List of functions

* [lag, lead](https://www.scopedb.io/docs/reference/functions/window/lag-lead.md)
* [row\_number](https://www.scopedb.io/docs/reference/functions/window/row_number.md)