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

Analytic functions are the last set of operations performed in a query except for the final ORDERBY clause. All joins and all WHERE , GROUPBY , and HAVING clauses are completed before the analytic ...

I'm <I>sure</I> 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 ...