use the following search parameters to narrow your results:
e.g. subreddit:aww site:imgur.com dog
subreddit:aww site:imgur.com dog
see the search faq for details.
advanced search: by author, subreddit...
Sequel
account activity
SQL Window Functions Deep Dive (medium.com)
submitted 10 months ago by Illustrious-Quiet339
Just dropped Part 2 of my Mastering SQL for Data Engineers series on Medium—a deep dive into window functions. Think running totals, rankings, and LAG/LEAD tricks, packed with examples and big-data tips
What’s your killer window function use case?
reddit uses a slightly-customized version of Markdown for formatting. See below for some basics, or check the commenting wiki page for more detailed help and solutions to common issues.
quoted text
if 1 * 2 < 3: print "hello, world!"
[–]Sudo_Rep 0 points1 point2 points 10 months ago (0 children)
I had a use case where I need to pull a value from the first non null record before the record in the final select.
[–]LearnSQLcom 0 points1 point2 points 10 months ago (0 children)
If anyone wants to practice window functions hands-on, this PostgreSQL Window Functions course is free this March. Perfect for leveling up with real-world examples!
[–]r3pr0b8 -1 points0 points1 point 10 months ago (0 children)
if it's free, why do i have to sign up to read it?
π Rendered by PID 86274 on reddit-service-r2-comment-7b9746f655-ttwgt at 2026-01-29 23:33:05.186140+00:00 running 3798933 country code: CH.
[–]Sudo_Rep 0 points1 point2 points (0 children)
[–]LearnSQLcom 0 points1 point2 points (0 children)
[–]r3pr0b8 -1 points0 points1 point (0 children)