Reference Guide > TDV Support for SQL Functions > Aggregate Functions > NTH
 
NTH
Returns the nth sequential value in the scope of the function, where n is a constant. The NTH function starts counting at 1, so there is no zeroth term. If the scope of the function has less than n values, the function returns NULL.
Syntax
NTH(int_value, expression)