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: Breath Like Testicles <hungfatt_at_arse.com>
Date: Tue, 21 Aug 2001 13:02:23 -0500
Message-ID: <to54t3t6db36bd@news.supernews.com>


Nono,

What I meant was displaying the columns of data with the sum at the bottom of the column.

Thanks for the help

"TurkBear" <noone_at_nowhere.com> wrote in message news:dh45ot8olpc42dbk29aivc6fr1uh4j7tma_at_4ax.com...
>
> Cross-posting is generally not a good thing,
>
> Try
>
> select username,sum(cash_balance) from table group by username;
>
> ( you might try reading the manual on SqlPlus, this is a VERY basic
question)
>
>
> "Breath Like Testicles" <hungfatt_at_arse.com> 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?
> >
> >Thanks in advance!
> >
> >BLT
> >
>
>
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> Check out our new Unlimited Server. No Download or Time Limits!
> -----== Over 80,000 Newsgroups - 19 Different Servers! ==-----
Received on Tue Aug 21 2001 - 13:02:23 CDT

Original text of this message

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