[Oracle] 서브쿼리 값을 order by 기준으로 가져오기

WITH W_TEST AS 

(

SELECT 1 AS NO, 'A' AS VAL FROM DUAL

UNION ALL SELECT 2 AS NO, 'C' AS VAL FROM DUAL

UNION ALL SELECT 3 AS NO, 'B' AS VAL FROM DUAL

)

SELECT  (SELECT MAX(VAL) FROM W_TEST) AS VAL_1

              , (SELECT MAX(VAL) KEEP (DENSE_RANK FIRST ORDER BY NO DESC) FROM W_TEST) AS VAL_2

FROM DUAL

;

 

----- 결과 -----

VAL_1 VAL_2

C        B