also, since you are trying to project all columns plus the aggregate, you will need to list all non-aggregate columns in a group by:
example: select column_1,column_2, ..., count(column2) as myCount from myTable group by column_1, column_2... ~ dina ----- Original Message ----- From: "Joshua 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 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
