Is this report format possible using straight SQL/SQL*Plus?

[BOTE: example alignment may be off due to various font widths]

Column 1 Column 2 Column 3

A        B        10
A        B        35
A        B        25


                ------

                  70


A        C        20
A        C        10


                ------

                  30


A        D        15     


A        E        35


A        F        10
A        F        20


                ------

                  30

I have not been able to produce the above output, instead I get the following output using compute & breaks:

Column 1 Column 2 Column 3

A        B        10
A        B        35
A        B        25


                ------

                  70


A        C        20
A        C        10


                ------

                  30


A        D        15     


                ------

                  15


A        E        35


                ------

                  35


A        F        10
A        F        20


                ------

                  30

So, Is it possible to 'not' subtotal 'every' line, but instead, only subtotal if there are 2 or more matches?

Thanks, Kappy Received on Fri Jun 23 2000 - 00:00:00 CDT