查询七天内的数据
select count(*)as count from hvac_alarm where COMPANY_ID= #{companyId} and ISDEL=0 and DATE_SUB(CURDATE(), INTERVAL 7 DAY)<= date(CREATE_TIME) select count(*)as count from hvac_alarm w
阅读背景：
MySQL 查询技巧
来源：互联网
分享到：
