Hello!!
I want to get result on Oracle as this one:

------------------
NAME PRICE
--------- ------
book 75.00
pen 12.35
notebook 5.05
<total> 92.4
------------------

I know that i may write query as this:
SELECT name, price FROM tbprices
UNION
SELECT 'total', sum(price) FROM tbprices

but it's not good.. I have long query and this method makes long time
and do one thing two times..
Is there any short solution about that..?

best Regards...Thanks

As the Wise Man (TK) says:

"Analytics rock, Analytics roll... "

Cheers.

Carlos.

ilkin.esrefli (AT) gmail (DOT) com wrote:
Look up BREAK, COMPUTE and SUM in your SQL*Plus documentation.

HTH

-g

ilkin.esrefli (AT) gmail (DOT) com wrote:
Go to Morgan's Library at www.psoug.org and click on Analytic Functions.
Scroll down to the SUM demo.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org