Oracle LISTAGG 서브쿼리 사용 예시 / MySQL GROUP_CONCAT

<!-- 엑셀 식대 금액 조회 -->    
<select id="excelEatLogSelectList" parameterType="VO" resultType="VO">
    /* VO.excelEatLogSelectList */         
    <![CDATA[     
         SELECT	 ROWNUM																					excelRow
              ,	 EL_SEQ																					elSeq       
              ,  CARD_NUM																				cardNum 
              ,  STATE																					state 
              ,  ATCH_FILE_ID 																			atchFileId       
              ,  TO_CHAR(TO_DATE(RGST_DT), 'YYYY.MM.DD')												rgstDt    
              ,  (SELECT TAD.NAME FROM t_ad_user TAD WHERE TAD.USE_YN = 'Y' AND TAD.SEQ = A.RGST_ID)	rgstId   
              ,  EAT_DATE																				eatDate
              ,  (SELECT LISTAGG(TAD.NAME, ',') WITHIN GROUP(ORDER BY TAD.NAME) 
                    FROM T_AD_USER TAD   
                   WHERE TAD.USE_YN = 'Y'
                     AND A.USER_SEQ LIKE '%' || '[' || TAD.SEQ || ']' || '%'
                    )     userSeq
              ,  PRICE 																					price 
              ,  RSTRN_NAME																				rstrnName
              ,  ETC																					etc    
          FROM	T_EAT_LOG A 
         WHERE  USE_YN='Y'           
           AND 	TO_CHAR(TO_DATE(RGST_DT), 'YYYY.MM') = #{schEtc01}
         ORDER	BY rgstDt
    ]]>        
</select>

1. 서브쿼리로 활용하는 예시

2. 검색대상 LIKE 검색전체