LEAD

LEAD(COLUMN_EXPRESSION, [, N[, FILL_VALUE]])

Equivalent to LEAD(COLUMN_EXPRESSION, -N, FILL_VALUE), in other words, returns the row following the current row by N.