Re: Sum Help

2002-06-03 Thread Dina Hess
just curious... isn't it more efficient to have the database perform this calc? ~ dina - Original Message - From: "Cameron Childress" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, June 03, 2002 2:17 PM Subject: RE: Sum Help

RE: Sum Help

2002-06-03 Thread Cameron Childress
[EMAIL PROTECTED]] > Sent: Monday, June 03, 2002 2:48 PM > To: CF-Talk > Subject: Sum Help > > > Ok.. I;ve got myself confused here... > > I have a table that has some numbers lets say 5 records (50, > 45, 33, 23, > 12) now I want to be able to select * from that ta

Re: Sum Help

2002-06-03 Thread Dina Hess
oshua Tipton" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, June 03, 2002 1:55 PM Subject: RE: Sum Help > select sum(column) as sumofcolumn > from table > > > -Original Message- > From: Kris Pilles [mailto:[EMAIL PROTECTE

RE: Sum Help

2002-06-03 Thread Joshua Tipton
select sum(column) as sumofcolumn from table -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:48 PM To: CF-Talk Subject: Sum Help Ok.. I;ve got myself confused here... I have a table that has some numbers lets say 5 records (50, 45, 33, 23

Sum Help

2002-06-03 Thread Kris Pilles
Ok.. I;ve got myself confused here... I have a table that has some numbers lets say 5 records (50, 45, 33, 23, 12) now I want to be able to select * from that table (not a problem). But I need to sum those numbers so that I can output sum(50+45+33+23+12)... How can I do this??? Is there an easy