Mybatis 정렬 순서에 대한 고찰...

<select id="selectTBDJDA01_list" resultType="com.bond.vo.Tbbondda01vo" parameterType="String">
		SELECT
			KISA_APLY_ID,
			APLY_SEQ,
			APLY_ID,
			USER_ID,
			USER_NM,
			USER_PSTN,
			APLY_TYPE,
			TO_CHAR(APLY_DT,'YYYY-MM-DD') AS APLY_DT,
			(SELECT COUNT(1) FROM TBDJDA11 DA11 WHERE DA11.KISA_APLY_ID = DA01.KISA_APLY_ID) AS PSTN_CNT,
			PROC_ID,
			(SELECT PROC_NM FROM TBDJDG01 DG01 WHERE DA01.PROC_ID = DG01.PROC_ID) AS PROC_NM,
			NADM_RSN,
			PROC_MNGR_ID,
			(SELECT TEL_NO FROM TBDJAA03 AA03 WHERE AA03.USER_ID = DA01.PROC_MNGR_ID) AS PROC_MNGR_TEL_NO,
			(SELECT COUNT(1) FROM TBDJDA23 DA23 WHERE DA23.TARGET_ID = DA01.KISA_APLY_ID AND DA23.APLY_ID = DA01.APLY_ID) AS OBJ_CNT,
			<![CDATA[
				(SELECT 'Y' FROM TBDJAB02 AB02 WHERE AB02.POCY_TYPE_VL::INTEGER >= (SELECT COUNT(1) FROM TBDJDA01 INDA01 
						WHERE INDA01.KISA_APLY_ID = DA01.KISA_APLY_ID AND INDA01.APLY_SEQ = DA01.APLY_SEQ AND INDA01.PROC_ID != 'P102') 
					AND POCY_TYPE_KEY = 'APLY_RE_COUNT'
				) AS RE_KISA_APLY_YN,
			]]>
			APLY_CHK_FILE_ID,
			(SELECT ORGIN_NM FROM TBDJDA09 DA09 WHERE DA09.FILE_ID = DA01.APLY_CHK_FILE_ID) AS APLY_CHK_FILE_NM,
			(SELECT RESULT_FILE_ID FROM TBDJDA17 WHERE KISA_APLY_ID = DA01.KISA_APLY_ID ORDER BY REG_DT DESC LIMIT 1) AS RESULT_FILE_ID,
			(SELECT ORGIN_NM FROM TBDJDA09 DA09 WHERE DA09.FILE_ID =
				(SELECT RESULT_FILE_ID FROM TBDJDA17 WHERE KISA_APLY_ID = DA01.KISA_APLY_ID ORDER BY REG_DT DESC LIMIT 1)
			) AS RESULT_FILE_NM,
			'Y' as is_dj
		FROM TBDJDA01 DA01
		WHERE USER_ID = #{user_id}
		<if test='kisa_aply_id != null and kisa_aply_id != ""'>
			AND UPPER(DA01.KISA_APLY_ID) LIKE '%' || ( SELECT UPPER(TRIM(#{kisa_aply_id})) ) || '%'
		</if>
		<if test='sort_type != null'>
			<choose>
				<when test='sort_type == "kisa_aply_id" '>
					ORDER BY KISA_APLY_ID, DA01.PROC_ID, DA01.APLY_DT DESC
				</when>
				<when test='sort_type == "aply_dt" '>
					ORDER BY DA01.APLY_DT DESC, DA01.PROC_ID, KISA_APLY_ID
				</when>
				<otherwise>
					ORDER BY DA01.PROC_ID, DA01.APLY_DT DESC, KISA_APLY_ID
				</otherwise>
			</choose>
		</if>
	</select>