WITH TMP AS

(

SELECT 'D0200002110009' AS DCMID, '5210039' AS DCID , 'M4' AS CONTENT_TYPE FROM DUAL UNION ALL

SELECT 'D0200002110009' AS DCMID, '5210038' AS DCID , 'M3' AS CONTENT_TYPE FROM DUAL UNION ALL

SELECT 'D0200002110009' AS DCMID, '5210037' AS DCID , 'M2' AS CONTENT_TYPE FROM DUAL UNION ALL

SELECT 'D0200002110009' AS DCMID, '5210036' AS DCID , 'SD' AS CONTENT_TYPE FROM DUAL UNION ALL

SELECT 'D0200002110012' AS DCMID, '5210035' AS DCID , 'SH' AS CONTENT_TYPE FROM DUAL UNION ALL

SELECT 'D0200002110012' AS DCMID, '5210034' AS DCID , 'HD' AS CONTENT_TYPE FROM DUAL UNION ALL

SELECT 'D0200002110009' AS DCMID, '5210033' AS DCID , 'SH' AS CONTENT_TYPE FROM DUAL UNION ALL

SELECT 'D0200002110009' AS DCMID, '5210032' AS DCID , 'HD' AS CONTENT_TYPE FROM DUAL

)

SELECT *

FROM TMP

ORDER BY CONTENT_TYPE

;

혹시...이거?

DCID DESC 기준 정렬 후에 다시 CONTENT_TYPE 하는거라면

ORDER BY DCID DESC, CONTENT_TYPE

음...? 주열이다...

1. TABLE1(DCMID, DCID, CONTENT_TYPE)

2. TABLE2(필드1, 필드2)

HD, 01

SH, 02

SD, 03

......

M2, 07

M3, 08

......

위와 같은 코드를 지정 후

SELECT *

FROM TAB1 T1, TAB2 T2

WHERE T1.CONTENT_TYPE = T2.필드1

ORDER BY T1.DCMID, T2.필드2

와 같이 하면 됨...

추가로 질문을 할 때 M2~M6만 설명을 했는데 SD, HD, SH는 정렬이 어떻게 되어야 하는지 등등의 내용도 함께 문의를 해야 정확한 답변을 받을 수 있어...