SQL SERVER||Use case of LEAD() and LAG() in RDBMS

LEAD() and LAG() These functions are called as Windows Functions.These are very much useful in generating reports. LEAD() accesses a value stored in a row below. LAG() function allows access to a value stored in a different row above the current row.