These functions accesses data from nth next row and nth previous row in the same result set without the use of a self-join.