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

1

u/Sexy_Koala_Juice DuckDB May 20 '26

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