表结构
id,money,date
1, 24, 2007-12-12
2, 66, 2007-12-28
3, 58.2, 2008-6-12
... ...请问如何得出年度每月销售额阿,小弟在这里先谢过各位了
id,money,date
1, 24, 2007-12-12
2, 66, 2007-12-28
3, 58.2, 2008-6-12
... ...请问如何得出年度每月销售额阿,小弟在这里先谢过各位了
select MONTH(consumetime),sum(moneyrecord) as num from user_consumerecord group by MONTH(consumetime)