Arnoud,
Will this work:
SELECT
SUM(C1) as C1_SUM,
SUM(C2) as C2_SUM,
...
SUM(C12) as C12_SUM,
SUM(C1) + SUM(C2) + ... + SUM(C12) as SUM_ALL
FROM
YOUR_TABLE
Good luck,
Ian Bjorhovde
----- Original Message -----
From: "Arnoud W. Morsink" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 28, 2001 3:50 PM
Subject: DB2EUG: help
> help
>
>
> I have twelve columns that I need to SUM, no problem. Within an SQL I now
> want to take all the SUM's and sum them. I can not find an example of
this
> in our shop and would appreciate any help.
>
>
> thank you.
>
>
>
> David K. Johnson
> CGI
> MVS Application Support
> E-mail: [EMAIL PROTECTED]
> Phone(direct line): 905-282-4229 Extension: 150 - 4229
> Page: 416-372-9838
> Floor 5th, 2920 Matheson Blvd East
> Mississauga, ON L4W 5J4
>
>
> =====
> To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
> For other info (and scripts), see
http://people.mn.mediaone.net/scottrmcleod
>
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
