Have a look at analytical functions (LAG() and the like)
- --- Original Message --- -
From: Walid Alkaakati
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Wed, 04 Jun 2003 05:10:14
Hi list ,
Can you help me please .
I have a report that
Walid
You can use SUM as an analytic function like this: -
SQL select credit, debit, sum(credit + debit) over (order by rowid) from
foo;
CREDIT DEBIT SUM(CREDIT+DEBIT)OVER(ORDERBYROWID)
-- -- ---
3 0
Hi ,
Iam looking on how to solve this in a report ,,,
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Walid Alkaakati
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and
How about
SELECT DEBIT,CREDIT,CREDIT-DEBIT
FROM WHATEVER_THE_TABLE
WHERE CREDIT*CREDIT=-1;
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, June 04, 2003 9:10 AM
To: Multiple recipients of list ORACLE-L
Hi list ,
Can you
Depending on the structure of your table, you can also use plain SQL with a
self-join, similar to:
select v1.cust_id
, v1.order_date
, v1.order_total
, sum(v2.order_total) cumulative_total
from orders v1
, orders v2
where v1.cust_id =
Thanks All ,
I solved the problem as follows :
I defined a sum summary column on same group with the reset on group
above it,the to add balance brought forward i
used the first summary function to add balance brought forward to
the first record.
Bay .
--
Please see the