LAG

Equivalents for analytic functions

MySQL. Usage of query variables

LAG and LEAD functions

About window functions