Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: quick question
Breath Like Testicles wrote:
>
> Hi all,
>
> Just wondering how I can sum columns in a query.
>
> For example is I were to select all users and their corresponding cash
> balances, how do I sum the cash balance column without having to export it
> to a spreadsheet?
In SLQ*Plus;
break on user_name, report
compute sum of balance on user_name, report
SELECT user_name,
balance
FROM emp_users
WHERE yada yada yada. . .
-- Andrew AllenReceived on Sat Aug 25 2001 - 07:29:04 CDT
![]() |
![]() |