Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie SQL
On Wed, 6 Nov 2002, thierry.constant1_at_free.fr wrote:
>
> Hi,
>
> I have the following table:
>
> SCORE OID TYPE
> -------- ------ -------
> 60 123 text
> 40 124 attach
> 37 123 attach
> 28 150 attach
> 13 123 attach
>
> What is the request to get the following: ( outer join ?? )
>
> CUMUL SCORE OID TYPE
> ----- ------ ------ -------
> 110 60 123 text
> 110 40 123 attach
> 110 37 123 attach
> 40 28 124 attach
> 28 13 150 attach
>
> where 110 = 60 + 37 + 13.
So, what OID match those numbers?
-- Galen deForest Boyer Sweet dreams and flying machines in pieces on the ground.Received on Wed Nov 06 2002 - 21:43:54 CST