# Understanding Window Functions

DevFeed: [Understanding Window Functions](<https://devfeed.tech/articles/understanding-window-functions-34517.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2013/08/understanding-window-functions/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2013-08-20T10:04:00Z

Content type: tutorial

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [SQL](<https://devfeed.tech/topics/sql.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Query (disambiguation)](<https://devfeed.tech/topics/query.md>), [Databases](<https://devfeed.tech/topics/databases.md>)

Tags: [aggregate](<https://devfeed.tech/tags/aggregate.md>), [array-agg](<https://devfeed.tech/tags/array-agg.md>), [article](<https://devfeed.tech/tags/article.md>), [database](<https://devfeed.tech/tags/database.md>), [functions](<https://devfeed.tech/tags/functions.md>), [partitioning](<https://devfeed.tech/tags/partitioning.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [query](<https://devfeed.tech/tags/query.md>), [sql](<https://devfeed.tech/tags/sql.md>), [window-functions](<https://devfeed.tech/tags/window-functions.md>)

## AI overview

A tutorial explaining SQL window functions, including window frames, aggregate calculations, partitioning, and practical examples using PostgreSQL and motor racing data.

## Source excerpt

There was SQL before window functions and SQL after window functions: that's how powerful this tool is. Being that of a deal breaker unfortunately means that it can be quite hard to grasp the feature. This article aims at making it crystal clear so that you can begin using it today and are able to reason about it and recognize cases where you want to be using window functions. *We see a part of the data as if through a little window*