ID_, PILOT_ID_, PILOT_PROJECT_NAME_, DOC_NAME_, DOC_YEAR_, DOC_NUM_, DOC_NO_, DOCUMENT_BASIS_, PILOT_LEVEL_, PILOT_SUPERVISOR_, TIME_PERIOD_, START_TIME_, ACCEPTANCE_TIME_, PILOT_FIELD_, PILOT_RUNWAY_, PILOT_RANGE_, PILOT_TARGET_, LEAD_UNIT_NAME_, GROUP_NAME_, UNIT_ID_, UNIT_NAME_, UNIT_CODE_, UNIT_GRADE_, TASK_DETAILS_, ITERATE_CAUSE_, ITERATE_TYPE_, PILOT_TYPE_, STATUS_, CLASSIFIED_, REMARKS_, CREATE_BY_, CREATE_NAME_, CREATE_ORG_ID_, CREATE_ORG_NAME_, CREATE_DEPT_ID_, CREATE_DEPT_NAME_, CREATE_TIME_, UPDATE_BY_, UPDATE_NAME_, UPDATE_ORG_ID_, UPDATE_ORG_NAME_, UPDATE_DEPT_ID_, UPDATE_DEPT_NAME_, UPDATE_TIME_, LAST_TIME_ SELECT iter.ID_, m.ID_ AS PILOT_ID_, m.PILOT_PROJECT_NAME_, m.DOC_NO_, m.DOCUMENT_BASIS_, m.PILOT_LEVEL_, m.TIME_PERIOD_, m.ACCEPTANCE_TIME_, m.PILOT_FIELD_, iter.STATUS_, m.STATUS_ AS PILOT_STATUS_, m.UNIT_NAME_, m.UNIT_ID_, m.UNIT_CODE_, m.UNIT_GRADE_ FROM ( SELECT *, ROW_NUMBER()OVER(PARTITION BY PILOT_ID_ ORDER BY CREATE_TIME_ DESC)num FROM BIZ_REFORM_ITERATE_PILOT_MANAGEMENT ) iter JOIN BIZ_REFORM_PILOT_MANAGEMENT m ON iter.PILOT_ID_=m.ID_ ${ew.customSqlSegment}