mysql查询最新修改时间的记录

方式一: 应用limit函数

SELECT id,task_type,update_time FROM task WHERE deleted=0 AND task_type = 'Display' ORDER BY update_time DESC LIMIT 1;

方式二: 应用max函数及子查询

SELECT id,task_type,update_time FROM task WHERE deleted=0 AND update_time = (select MAX(update_time) FROM task ) AND task_type = 'Display' GROUP BY id;