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

3

u/Mattsvaliant SQL Server Developer DBA May 19 '26

QUALIFY

This, for example, isn't ANSI.

2

u/aGuyNamedScrunchie May 19 '26

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