sql一对多查询最大值的列出来

一对多查询最大

SELECT

c.TEMPLATE_ID,
c.FORM_DATA,
c.FINISH_DATE,
c.`NAME`,
c.CUSTOM_TASK_ID,
c.USER_ID
FROM
ADQM_CUSTOM_TASK c
INNER JOIN (
SELECT
TEMPLATE_ID,
MAX(FINISH_DATE) AS MAX_ID
FROM
ADQM_CUSTOM_TASK
GROUP BY
TEMPLATE_ID DESC
) d ON c.TEMPLATE_ID = d.TEMPLATE_ID
AND c.FINISH_DATE = d.MAX_ID