Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> 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
![]() |
![]() |