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