Re: Sum values originated from distinct rows in a join

From: joel garry <joel-garry_at_home.com>
Date: Fri, 24 Jul 2009 09:50:46 -0700 (PDT)
Message-ID: <21a730cb-f336-45b3-91b5-dfbe17013f04_at_j32g2000yqh.googlegroups.com>

On Jul 24, 4:19 am, "Álvaro G. Vicario"
<alvaro.NOSPAMTH..._at_demogracia.com.invalid> wrote:

>
> I believe I could get the correct result with SUM() OVER() but I can't
> make it work (I don't understand how analytic clauses work). Is is possible?
>

See http://www.orafaq.com/usenet/comp.databases.oracle.server/2007/08/03/0224.htm

jg

--
_at_home.com is bogus.
But you don't have to worry until God tweets back:
http://www3.signonsandiego.com/stories/2009/jul/24/western-wall-helps-faithful-tweet-god/?uniontrib

Received on Fri Jul 24 2009 - 11:50:46 CDT