mysql - 从数据库表中获取每月的记录

Question

我想根据某些条件从表中检索记录

看到这是我的条件:查询以根据每月的交易类型获取金额总和

下面是我的表格:

+-----------+-------------+
| Field     | Type        |   
+-----------+-------------+
| tran_id   | int(5)      | 
| cus_name  | varchar(30) | 
| acc_no    | int(10)     | 
| tran_date | date        | 
| amount    | int(6)      | 
| tran_type | varchar(20) | 
| cus_id    | int(5)      | 
+-----------+-------------+

按照以下格式显示月份值。

+-----------+-------------+
| Month     | Month Name  |   
+-----------+-------------+
| 01        | January     | 
| 02        | February    | 
+-----------+-------------+

Answer 1

我认为这就是您所需要的。

select sum(amount) Sum,tran_type,MONTH(tran_date) Month,MONTHNAME(tran_date) Month Name from your_table group by tran_type,MONTH(tran_date);`

`