# Window Functions example remix

DevFeed: [Window Functions example remix](<https://devfeed.tech/articles/window-functions-example-remix-34393.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2010/09/window-functions-example-remix/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2010-09-12T19:35:00Z

Content type: article

Language: en

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

Topics: [SQL](<https://devfeed.tech/topics/sql.md>), [Structured-data](<https://devfeed.tech/topics/structured-data.md>)

Tags: [sql](<https://devfeed.tech/tags/sql.md>), [window-functions](<https://devfeed.tech/tags/window-functions.md>)

## AI overview

A follow-up to a previous SQL entry presents David Fetter's rewrite of a window-functions example. The rewrite filters the first change in a subquery rather than removing it at the outer level; the author is unsure which approach is cleaner but considers one simpler.

## Source excerpt

The drawback of hosting a static only website is, obviously, the lack of comments. What happens actually, though, is that I receive very few comments by direct mail. As I don't get another spam source to cleanup, I'm left unconvinced that's such a drawback. I still miss the low probability of seeing blog readers exchange directly, but I think a tapoueh.org mailing list would be my answer, here... Anyway, David Fetter took the time to send me a comment by mail with a cleaned up rewrite of the previous entry SQL, here's it for your pleasure!