RE: sum the values in a group by statement....

select col1, col2, sum(col1+col2) from table1 group by col1

The col you group by must be in your field list. Also, you can't group by
ASC and DESC Groups just.  What you need to add is a where clause to specify
only certain records be included in the groupings.

=C=

*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*


-----Original Message-----
From: Ciprian I. Acatrinei [mailto:cia@xxxxxxxxxxx]
Sent: Friday, June 28, 2002 1:51 PM
To: Mysql List
Subject: sum the values in a group by statement....


Hi,

Can someone give me the mysql syntax or a reference link where I can learn
how
to group the values in a select statement and also ADD the values of
some of the columns.

For example:

select column1, column2, column3 from table1 group by 1 asc,2 desc;

I want the values presented in the column3 to be the sum of all the rows
that matched the group condition.

Am I clear enough?


Thank you.
Ciprian


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread113349@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-cal=calevans.com@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread113357@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail 
<mysql-unsubscribe-gcdmg-mysql=m.gmane.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php