This is the same as the NTH VALUE function with the optional FROM LAST and IGNORE NULLS options. Refer NTH_VALUE