SQL Server: Lead vs Lag

echiang written 5 years ago

The LAG function has the ability to fetch data from a previous row, while LEAD fetches data from a subsequent row.

Sources:

https://www.mssqltips.com/sqlservertutorial/9127/sql-server-window-functions-lead-and-lag/

Last modified: January 20, 2020

You must be logged in to post a comment.