Lead and Lag

Analytical functions that are used to calculate the difference between rows in a table. LEAD calculates the difference between the current row and the following row, while LAG calculates the difference between the current row and the previous row.

» Business Intelligence Glossary