News for hackers. Stuff that matters.
Re:Introduction to Window Functions in SQL by throw_m239339 on Wednesday January 06, 2021 @06:24AM (#25656727)
Introduction to Window Functions with the same examples (salaries per department)

https://www.postgresql.org/docs/13/tutorial-window.html

While you are at it, check out common table expressions as well

https://www.postgresql.org/docs/13/queries-with.html

Re:Introduction to Window Functions in SQL by adilkhash on Wednesday January 06, 2021 @06:33AM (#25656774)
okay, thanks :)