SQLPlus Grand Totals [message #41556] |
Fri, 10 January 2003 09:25 |
denny
Messages: 9 Registered: August 2002
|
Junior Member |
|
|
Hi All
Don't know if this is possible in SQLPlus....
Can you ask SqlPlus to supply Grand Totals in
addition to sum totals:
We have a sql script that sums(pieces_mailed) by
campaign...however mgt would like to have a
grand total appear at the end of print out.
example:
Campaign sum(pieces_mailed)
2002 Appeal 10000
2002 Victory 5000
2003 Gift Card 2500
======
grand total 17500
I was wondering if this is possible in SQLPlus
so I wouldn't have to write a PLSQL procedure.
thanks in advance
|
|
|
|
|