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, 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 way am I forgetting something??? KP ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
