"Ian D. Bjorhovde" wrote: > 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
begin:vcard n:Madipadga;Reddy tel;fax:(208) 692-6856 tel;work:(512)918-8752 x-mozilla-html:FALSE org:Leosoft Inc version:2.1 email;internet:[EMAIL PROTECTED] title:President adr;quoted-printable:;;8700 Wafer Ash Way=0D=0A;Austin, TX - 78750;;; x-mozilla-cpt:;-27888 fn:Reddy Madipadga end:vcard
