分组后，获取最新一条记录SQL

SELECT *
FROM(
SELECT t2.submit_time,t2.apply_id,
ROW_NUMBER() OVER (PARTITION BY t2.apply_id ORDER BY submit_time DESC ) AS rn
FROM t_exam_user_info t2
WHERE t2.deleted = 0
AND t2.submit_time IS NOT NULL
) e
WHERE e.rn = 1