Skip to main content

Running Totals & Moving Averages

Learn Running Totals & Moving Averages (Window Functions, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction A running total is a cumulative SUM over an ordered window ending at the current row. A moving average is an AVG over a small sliding frame, which smooths noisy data.

More lessons in Window Functions