SQL lag and lead
LAG and LEAD retrieve nearby values for changes between successive observations.
4 minutes. No sign-up needed.
This lesson is part of the Data Analytics course.
Example plan3 lessons · 12 min
SQL ranking functions4 min
SQL lag and leadAdvanced analytical SQL4 min
SQL window framesAdvanced analytical SQL4 min
An example. Your plan follows your answers, so it can start later and end sooner.
Build my plan
Start free, no account needed.