一、数据库表pension_money
num varchar(5)
sendDate varchar(10)
amount int
数据库数据
num | sendDate | amount |
1 | 20141001 | 201 |
2 | 20141002 | 102 |
3 | 20141003 | 110 |
4 | 20141101 | 100 |
5 | 20141102 | 118 |
6 | 20141103 | 175 |
Q:按月份求出每个月的养老金总金额
select sum(amount) from pension_money group by month(sendDate);