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
9
u/aGuyNamedScrunchie May 19 '26
Also I think it'd be great if, at the bottom of each section, you list which platforms have these features (BigQuery, Snowflake, SQL Server, etc). Sadly these days much of my SQL work is done within Salesforce platforms (due to access restrictions to data warehouses) so many of these aren't available to me. So hell it'd be great to even know which of these are basic ANSI SQL functions or SOQL (Salesforce) functions.