Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Please help: SELECT with calc
Why does this give different results? What is the column definition? If you happen to sum floating numbers I could imagine your trouble, but please provide more details by e-mail.
Martin Haltmayer
NNOOR wrote:
>
> I have a few columns in a table (DAY_1, DAY_2...DAY_14). I want to
> sum all of these columns accross all of the records. i.e. what is
> the total of all numbers in all DAY_x fields for a given WHERE
> criteria. It should be pretty simple but I can't figure it out.
>
> I tried following but both gave different and wrong results.
>
> (assuming columns are DAY_1, DAY_2 and DAY_3)
>
> SELECT (DAY_1 + DAY_2 + DAY_3) from xxx.yyy
> where ...
>
> AND
>
> SELECT (((DAY_1) + DAY_2) + DAY_3) from ...
> where ...
>
> Thanks very much for your help!!!
>
> Regards,
> Nasir (nnoor_at_cris.com)
Received on Mon Nov 03 1997 - 00:00:00 CST