Define Lead and Lag functions in SQL.
Gajendra Jangid
These functions accesses data from nth next row and nth previous row in the same result set without the use of a self-join.