NTH_VALUE

NTH_VALUE returns the expression value of the nth row in the window defined by the window clause. The returned value has the data type of the expression.

Syntax

NTH_VALUE (expression, nth_row) [FROM FIRST | FROM LAST] [IGNORE NULLS] OVER (window_clause)

Remarks

•

FROM LAST is optional.

•

If FROM LAST is not specified, FROM FIRST is the default.