CLOB 타입 있을경우 GROUP BY 방법

CLOB 타입 있을경우 GROUP BY 방법

SELECT AA.*, (SELECT  BODY_TEXT
    FROM  LIFE_NEWS_T WHERE CONTENT_ID = AA.CONTENT_ID
 AND ROWNUM = 1) AS BODY_TEXT  -- CLOB 타입
FROM
(SELECT
               A.CONTENT_ID      -- 내용식별코드
              , MAX(A.SEQ_LIFE_NEWS)  "SEQ_LIFE_NEWS" 
              ,MAX(A.NEWS_TYPE) "NEWS_TYPE"       -- CODE_EXT_T 참조(속보,지역뉴스,포토)
              ,MAX(A.REGI_DATE) "REGI_DATE"       -- 뉴스등록일
              ,MAX(A.NEWS_REGION_TYPE) "NEWS_REGION_TYPE"       -- CODE_EXT_T 참조
              ,MAX(A.TITLE )  "TITLE"     -- 뉴스 타이틀
              ,MAX(A.SEND_TIME) "SEND_TIME"       -- 뉴스송신일
              ,MAX(A.EDIT_DATE) "EDIT_DATE"       --
        FROM  LIFE_NEWS_T A
        WHERE NEWS_SUB_TYPE_LIST LIKE '%%'
          GROUP BY CONTENT_ID) AA
ORDER BY AA.REGI_DATE;

 

<script src="http://hsw85.tistory.com/plugin/CallBack_bootstrapper?&src=http://s1.daumcdn.net/cfs.tistory/v/0/blog/plugins/CallBack/callback&id=125&callbackId=hsw85tistorycom1257641&destDocId=callbacknesthsw85tistorycom1257641&host=http://hsw85.tistory.com&float=left&random=72"></script>

[출처] CLOB 타입 있을경우 GROUP BY 방법|작성자 신강유