Re: COUNT(...) OVER(...)

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Fri, 26 Jun 2009 19:59:21 +0200
Message-ID: <7akgk0F1uec5mU1_at_mid.individual.net>



On 25.06.2009 13:06, Álvaro G. Vicario wrote:
> I'm trying to learn about analytic functions, more specifically the
> OVER() clause applied to COUNT() and AVG() functions. I've read the SQL
> Reference and I've found several examples in Google but I still can't
> grasp the concept.

Oracle has pretty good documentation online:

http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14223/analysis.htm

http://www.oracle.com/technology/products/bi/pdf/o9i_analyticsql_twp.pdf

HTH         robert

-- 
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/
Received on Fri Jun 26 2009 - 12:59:21 CDT

Original text of this message