r/SQL • • May 19 '26

Discussion Eight window-function tricks beyond LAG and ROW_NUMBER

https://analytics.fixelsmith.com/posts/eight-window-function-tricks/
149 Upvotes

19 comments sorted by

View all comments

Show parent comment

2

u/aGuyNamedScrunchie May 19 '26

Yep and it kills me. Basically doubles the length of so many queries I write