SQL - NTH_VALUE() Function
The NTH_VALUE() function returns the value of an expression from the nth row in an ordered set of rows within a window partition. The basic syntax:
The NTH_VALUE() function returns the value of an expression from the nth row in an ordered set of rows within a window partition. The basic syntax: