Re: Please help: SELECT with calc

From: Authorized User <mmelanco_at_sfi-software.com>
Date: 1997/10/31
Message-ID: <63cuch$a34$1@news.igs.net>#1/1

select sum(DAY_1 + DAY_2 + DAY_3) from ...

This will be a tuff one if the table is big

Marc

NNOOR wrote in message <63balm$4tc_at_examiner.concentric.net>...
>
>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