SQL SQL LAG, LEAD and Running Totals: Window Frames Explained
Learn the SQL running total with SUM OVER, LAG and LEAD for month-over-month change, moving averages, ROWS vs RANGE vs GROUPS frames…
November 18, 2026 · 13 min read
Topic
Uncategorized
0 guides
Coming soon
Guides on Uncategorized are on the way
Join the newsletter and you’ll get the first guides in this topic as soon as they’re published.
Get the free SQL cheat sheet
One page with the SQL joins, window functions and query patterns you’ll use every day. Join the newsletter and I’ll send it straight to your inbox.
Explore other topics
While you wait, start with one of these:
AI & Agents
Data Engineering
Data Science
Machine Learning
Language Models
NLP
Computer Vision
MLOps
SQL & Databases
Python
Programming
Career Advice



