#SQL-window_value_functions

Looking Back and Forward: LAG() and LEAD() in SQL

Most window functions look at the current row and summarise its neighbours. LAG() and LEAD() do something more direct: they reach out and grab a value...