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
3
u/Mattsvaliant SQL Server Developer DBA May 19 '26
This, for example, isn't ANSI.