select a.* from data_subtaskregionschedule a inner join(select subregionid,max(updatetime) maxupdatetime
from data_subtaskregionschedule group by subregionid) b on a.subregionid=b.subregionid and a.updatetime
=b.maxupdatetime;
实测可行
原文：https://www.cnblogs.com/xiaoyuersdch/p/8945281.html