I have some sql(below) that when run gives me Result #1.
What I'm trying to do is to have week 1 roll into week 2, and the total
from week 2 roll into week 3 and so forth.
I've played around with the "rollup" function but I can't get it to come
out like Result #2.
Anyone have any ideas or a way I could get the "rollup" function to produce
results like #2?
SELECT ROUND(SUM(t1.baseline_budget),0) cc_budget,
t2.week_seq
FROM ipcs.all_cost_view_outage t1,
ipcs.week_detail t2
WHERE t2.week_seq = t1.week_seq
AND t2.week_detail.proj_id = 2108
GROUP BY t2.description,
t2.week_seq;
Result #1
Budget Week
100 1
100 2
100 3
100 4
Result #2
Budget Week
100 1
200 2
300 3
400 4
Thanks all...........
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
