#推送总数量
SELECT COUNT(*) FROM tab;
#30分钟内的推送数
SELECT COUNT(*) FROM tab WHERE COLLECTED_TIME IS NOT NULL AND '时间字段值1' - '时间字段值2' < 1800;
#30分钟外的推送数
SELECT COUNT(*) FROM tab WHERE '时间字段' IS NOT NULL AND CREATE_TIME - COLLECTED_TIME >= 1800;
#本月内的推送数
SELECT COUNT(*) FROM tab WHERE DATE_FORMAT('时间字段','%Y-%m')=DATE_FORMAT(NOW(),'%Y-%m');
#本周内的推送数
SELECT COUNT(*) FROM tab WHERE YEARWEEK(DATE_FORMAT('时间字段','%Y-%m-%d')) = YEARWEEK(NOW());
#近三月的推送数
SELECT COUNT(*) FROM tab WHERE '时间字段' BETWEEN DATE_SUB(NOW(),INTERVAL 3 month) AND NOW();
统计例子:
#推送总数量
SELECT COUNT(*) FROM kf_demand_push;
#30分钟内的推送数
SELECT COUNT(*) FROM kf_demand_push WHERE COLLECTED_TIME IS NOT NULL AND CREATE_TIME - COLLECTED_TIME < 1800;
#30分钟外的推送数
SELECT COUNT(*) FROM kf_demand_push WHERE COLLECTED_TIME IS NOT NULL AND CREATE_TIME - COLLECTED_TIME >= 1800;
#本月内的推送数
SELECT COUNT(*) FROM kf_demand_push WHERE DATE_FORMAT(CREATE_TIME,'%Y-%m')=DATE_FORMAT(NOW(),'%Y-%m');
#本周内的推送数
SELECT COUNT(*) FROM kf_demand_push WHERE YEARWEEK(DATE_FORMAT(CREATE_TIME,'%Y-%m-%d')) = YEARWEEK(NOW());
#本周内的推送数(统计写法2)
SELECT COUNT(*) FROM kf_demand_push WHERE MONTH(CREATE_TIME)=MONTH(CURDATE()) AND WEEK(CREATE_TIME) = WEEK(CURDATE());
#近三月的推送数
SELECT COUNT(*) FROM kf_demand_push WHERE CREATE_TIME BETWEEN DATE_SUB(NOW(),INTERVAL 3 MONTH) AND NOW();