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

Question

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.

Answer 1

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

Good luck,

peng

http://www.eptop.com

Answer 2

Take your pick.

http://www.google.co.uk/search?client=op...