删除一张表中 小于最大时间的sql

UPDATE ftb_cultivate_identify_apply_details AS app_detail
JOIN (SELECTF_ApplyId AS applyId,MAX(F_CreatorTime) AS max_timeFROM ftb_cultivate_identify_apply_details where ftb_cultivate_identify_apply_details.F_DeleteMark = 0GROUP BY F_ApplyId
) AS max_times ON app_detail.F_ApplyId = max_times.applyId
SET app_detail.F_DeleteMark = 1
WHERE app_detail.F_CreatorTime < max_times.max_time;