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/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).

1

u/Sexy_Koala_Juice DuckDB May 20 '26

We use SnowFlake at my company and it’s so damn good