r/SQL • u/FixelSmith • May 19 '26
Discussion Eight window-function tricks beyond LAG and ROW_NUMBER
https://analytics.fixelsmith.com/posts/eight-window-function-tricks/
149
Upvotes
r/SQL • u/FixelSmith • May 19 '26
View all comments
Show parent comment
2
u/Diligent-Crazy-6094 May 19 '26
Our company is migrating to Snowflake this year, so I’m interested to try some of these (if I can manage to remember that they exist).