摘要:按年汇总,统计: select sum(mymoney) as totalmoney, count(*) as sheets from mytable group by date_format(col, '%Y'); 按月汇总,统计: select sum(mymoney) as totalmone 阅读全文
posted @ 2018-01-31 10:27 丨Mars 阅读(3894) 评论(0) 推荐(0) 编辑