Can someone help me with this BASIC SQL query

From: CL <thecure_at_rcn.com>
Date: Sat, 22 Mar 2003 10:40:34 -0500
Message-ID: <b5i09g$jqo$1_at_bob.news.rcn.net>

I am a bit rusty on SQL and need to quickly come up with a query against fiels like this:
assume DIVISION, DEPT, DATE, REVENUE and get output GROUPED by DIVISION and DEPT and DATE and with SUM(REVENUE) ... Im having trouble with the combination of BREAK and GROUP...
i.e. I want to get the SUB-TOTALS working... If I want to get this output what SQL do I use???

        DEPT1:
                Month 01 ... Revenue
                Month 02 ... Revenue
                ...
                Year total:    Total of above Revenue for DEPT1
        DEPT2:
                Month 01
                    (same as above)
DIV2:
        DEPT 21:
                Month 01 ... Revenue
        (Same as above)

Total of all DIVISIONS...

THANK YOU!!! Received on Sat Mar 22 2003 - 16:40:34 CET

This message: [ Message body ]
Next message: amanda: "Re: Oracle 8I vs. Oracle 9i"
Previous message: Oracle User: "Peformance degradation during array fetch in Pro*C"
Next in thread: D.Y.: "Re: Can someone help me with this BASIC SQL query"
Reply: D.Y.: "Re: Can someone help me with this BASIC SQL query"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message