select t1.*
from sys_job_log t1
inner join (
select job_id,max(taskTime) taskTime from sys_job_log GROUP BY job_id
) t2 on t2.job_id=t1.JOB_ID and t2.taskTime=t1.taskTime
MySQL 使用SQL语句筛选出最新的一条记录
最新推荐文章于 2024-06-14 13:13:00 发布