sql根据日期查询近6月数据(包括当前月往前推五个月)

最新推荐文章于 2024-12-16 17:26:29 发布

背手夹包剃炮头

最新推荐文章于 2024-12-16 17:26:29 发布

阅读量1.2k

点赞数

文章标签： sql 数据库 java

本文链接：https://blog.youkuaiyun.com/weixin_56911379/article/details/130597788

版权

SELECT
DATE_FORMAT( create_time, '%Y年%m月' ) AS months,
COUNT( CASE WHEN fe.data_type = 1 THEN fe.id END ) AS repairNumber,
COUNT( CASE WHEN fe.data_type = 2 THEN fe.id END ) AS installNumber,
COUNT( CASE WHEN fe.data_type = 3 THEN fe.id END ) AS informationChangeNumber,
COUNT( CASE WHEN fe.data_type = 4 THEN fe.id END ) AS transferNumber,
COUNT( CASE WHEN fe.data_type = 5 THEN fe.id END ) AS untableNumber
FROM
fj_declare fe
WHERE
fe.create_time BETWEEN date_sub( now(), INTERVAL 5 MONTH )
AND now()
AND fe.is_delete = 0
GROUP BY
months