-- Analytical functions are otherwise called as windowing or Online Analytic Processing (OLAP) functions. -- Analytical Functions - Rank(), Dense_Rank() , Row_number ...

REM SQL from the KISS (Keep It Simply SQL) Analytic video series by Developer Advocate Connor McDonald. This script is for deriving the nth_value from within a window ...

I'm sure Oracle's analytic functions can handle this, but I'm having a hard time wrapping my head around the syntax. If anyone has another solution, I'd be happy to hear it too.