Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: quick question

Re: quick question

From: Andrew Allen <ajallen_at_mailhost.det.ameritech.net>
Date: Sat, 25 Aug 2001 12:29:04 GMT
Message-ID: <3B879A27.D24EA030@mailhost.det.ameritech.net>

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 Allen
Received on Sat Aug 25 2001 - 07:29:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US