Re: Please help: SELECT with calc

You will need to use a cursor...
Nnoor_at_cris.com (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 Fri Oct 31 1997 - 00:00:00 CST