Thread: Oracle analytic functions

Oracle analytic functions

From
Christopher Kings-Lynne
Date:
Hi guys,

I thought I'd pass this around as an interested reference page.  Gives 
us an idea of how far we need to go to compete with Oracle for data 
analysis...

http://www.akadia.com/services/ora_analytic_functions.html

Interesting stuff:
* Accessing rows around your current row
* Lag, lead
* Top N queries
* Ranges
* etc.

Cheers,

Chris