Window Functions

Paging records

Window functions

Running totals

Correlated subqueries

Equivalents for analytic functions

MySQL. Usage of query variables

Other examples of using window functions

Window functions

LAG and LEAD functions

Window functions

Window functions

New sql features

MySQL. Usage of query variables

Optimizing

Aggregate function to aggregate function

Getting summarizing values