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

After the database server has completed all of the steps necessary to evaluate a query, including joining, filtering, grouping, and sorting, the result set is complete and ready to be returned to the ...

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 ...