Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Running total query.

Re: Running total query.

From: Alex Filonov <afilonov_at_pro-ns.net>
Date: 2000/05/26
Message-ID: <8gmqq1$qe6$1@nnrp1.deja.com>#1/1

In article <392AEF36.8195423A_at_non.hp.com>,   Michael Rothwell <mike_rothwell_at_non.hp.com> wrote:
> Has anyone come up with an easy solution to get running balances in a
> query?
>
> If I have a table tA that has columns c1 number (pk), c2 number, c3
> number
>
> I would like a query that returns the prime key ( c1 ) , c2, c3, and a
> running total of prior running total + c2 - c3
>
> c1 c2 c3 running total
> ------- -------- --------- ---------------
> 1 500.00 0.00 500.00 ( 500 + 0 = 500
 )
>
> 2 0.00 450.00 50.00 ( 500 + 0 -
 450
> = 50 )
> 3 200.00 150.00 100.00 ( 50 + 200 - 150
 =
> 100 )
>
> Thanks for any input.
>
> Michael
>

Not in SQL. You can do it, of course, but price will be high (you need complex query). But in Oracle Report you can define summary column on any database column or function column and make it accumulative.

Alex Filonov.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri May 26 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US