SELECT device_id,MAX(b.create_time) AS recent_warning_time FROM test
GROUP BY a.device_id HAVING HOUR( timediff( now(), recent_warning_time) ) > 24
mysql 查询最近一条数据时间大于24小时
于 2022-02-28 10:52:07 首次发布
SELECT device_id,MAX(b.create_time) AS recent_warning_time FROM test
GROUP BY a.device_id HAVING HOUR( timediff( now(), recent_warning_time) ) > 24