Re: quick question

BLT:   select username,sum(cash_balance)
    from table
group by rollup (username)

(p.s. Can I be so bold as to ask which is your given name and which is your family name?)

Breath Like Testicles wrote:
>
> 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 - 17:16:27 CDT