SELECT * FROM test WHERE DATE_FORMAT(sumtime,'%Y-%m-%d')>='2014-08-01' AND DATE_FORMAT(sumtime,'%Y-%m-%d')<='2014-08-20' AND DATE_FORMAT(sumtime,'%H')>=18 AND DATE_FORMAT(sumtime,'%H')<=20
SELECT * WHERE sumtime >1 AND sumtime <20
select month,ifnull(sum(汇总字段),0) from 表 where 条件 group by month;
满意请采纳。
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024