How do we calculate table row´s value in Mysql?

Sep

princeexpedition asked:

anybody would like to suggest me how can i calculate table row´s item values group by month in Mysql?

Actually, i have a table with some row´s item value. and i want to them group by month.

Comments

Gasman on 6 September, 2008 at 1:38 pm #

Take your pick.

bigbird on 6 September, 2008 at 6:54 pm #

SELECT month, SUM(col1), SUM(col2) FROM tbl GROUP BY month;

Good luck,
peng