1.sql语句,根据月份分组进行查询
(1)数据库的格式
CREATE TABLE `project_info` (
`project_id` VARCHAR ( 64 ) NOT NULL COMMENT '项目信息表id',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
`create_by` VARCHAR ( 255 ) NOT NULL DEFAULT 'admin' COMMENT '创建人',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`update_by` VARCHAR ( 255 ) DEFAULT 'admin' COMMENT '更新人',
`status` INT ( 2 ) NOT NULL DEFAULT '0' COMMENT '数据状态 0:正常 -1:禁用',
`is_delete` INT ( 1 ) NOT NULL DEFAULT '0' COMMENT '是否删除 0:正常 -1:删除',
PRIMARY KEY ( `project_id` ),
KEY `is_recycle` ( `is_recycle` ) USING BTREE,
KEY `is_warning` ( `is_warning` ),
KEY `is_distribute` ( `is_distribute` ),
KEY `is_delete` ( `is_delete` )
) ENGINE = INNODB DEFAULT CHARSET = utf8mb4 COMMENT = '项目信息表';
(2)sql语句
select sum(plan_invested_amount_centre),DATE_FORMAT(create_time, '%Y-%m') from project_info
WHERE is_delete=0 GROUP BY DATE_FORMAT(create_time, '%Y-%m');
(3)查询的结果
更多推荐
sql语句,根据月份分组进行查询
发布评论