[SQL] Lead & Lag Window Function
This tutorial will walk you through SQL server on using the Lead or Lag function. Adding this to your SQL select statement, it can output you the previous/next data value in the partition. This is very useful when wanting to see a particular data value a customer had prior to making a change.
Github Script:
https://github.com/ProfessorPitch/Pro...
Lag:
https://docs.microsoft.com/en-us/sql/...
Lead:
https://docs.microsoft.com/en-us/sql/...