Re: SQL Query - Sum

Try this:

select t.paid, tt.total
from test t, (select sum(paid) total from test) tt

FYI the word "total" after the sum(paid) is an alias not a function.

Larry

In article <8e715f$6do$1_at_nnrp1.deja.com>,   Toshi Teruya <tteruya_at_sportsmail.com> wrote:
> Test table as follows:
>
> paid
> ----
> 25
> 25
> 50
> 50
>
> I would like to execute a query to return the following:
>
> paid total
> ---- -----
> 25 150
> 25 150
> 50 150
> 50 150
>
> The following query below works in MS Access:
>
> select paid, (select sum(t.paid) from test t) as total from test;
>
> But the query does not work in Oracle. An ORA-00936: missing
 expression
> occurs.
>
> I would prefer not to add a total column and run an update statement
 to
> sum since the table size will change. I would also prefer not to use a
> function. If anyone knows of any other way...
>
> Thanks in advance,
>
> Toshi
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Apr 26 2000 - 00:00:00 CDT