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

UPDATE ftb_cultivate_identify_apply_details AS app_detail
JOIN (
    SELECT
        F_ApplyId AS applyId,
        MAX(F_CreatorTime) AS max_time
    FROM ftb_cultivate_identify_apply_details where ftb_cultivate_identify_apply_details.F_DeleteMark = 0
    GROUP 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;