This lesson is for subscribers
You've completed the free preview. Subscribe to unlock every lesson in every course.
Lesson 1027 of 2,145·26. Advanced SQLPro lesson
Combining LAG and LEAD for Context
Use both functions together to compare current values with both previous and next values simultaneously.