순위(1.AA, 2.AC, 3.TD...)에 대한 기준은 따로 있는건가요?

아니요... 저 순서대로 데이터를 축출해달라는 요청입니다.

WITH LST AS (
SELECT '20230601' DY, 'AA' CD FROM DUAL UNION ALL
SELECT '20230601' DY, 'AB' CD FROM DUAL UNION ALL
SELECT '20230601' DY, 'AC' CD FROM DUAL UNION ALL
SELECT '20230602' DY, 'AC' CD FROM DUAL UNION ALL
SELECT '20230602' DY, 'TD' CD FROM DUAL UNION ALL
SELECT '20230602' DY, 'AB' CD FROM DUAL UNION ALL
SELECT '20230603' DY, 'TD' CD FROM DUAL UNION ALL
SELECT '20230603' DY, 'PP' CD FROM DUAL UNION ALL
SELECT '20230604' DY, 'ZZ' CD FROM DUAL
),
MST AS (
SELECT 'AA' CD, 1 RK FROM DUAL UNION ALL
SELECT 'AC' CD, 2 RK FROM DUAL UNION ALL
SELECT 'TD' CD, 3 RK FROM DUAL
),
RANKED_LST AS (
SELECT LST.DY, LST.CD, MST.RK,
       ROW_NUMBER() OVER (PARTITION BY LST.DY ORDER BY MST.RK) AS RN
  FROM LST
  LEFT JOIN MST ON LST.CD = MST.CD
)
SELECT DY, CD, RK
  FROM RANKED_LST
 WHERE RN = 1 AND RK IS NOT NULL
 ORDER BY DY;

WITH tbl AS (
	SELECT '20230601' DY, 'AA' CD FROM DUAL UNION ALL
	SELECT '20230601' DY, 'AB' CD FROM DUAL UNION ALL
	SELECT '20230601' DY, 'AC' CD FROM DUAL UNION ALL
	SELECT '20230602' DY, 'AC' CD FROM DUAL UNION ALL
	SELECT '20230602' DY, 'TD' CD FROM DUAL UNION ALL
	SELECT '20230602' DY, 'AB' CD FROM DUAL UNION ALL
	SELECT '20230603' DY, 'TD' CD FROM DUAL UNION ALL
	SELECT '20230603' DY, 'PP' CD FROM DUAL UNION ALL
	SELECT '20230604' DY, 'ZZ' CD FROM DUAL
)
SELECT 
	DY, CD 
FROM (
	SELECT
		tbl.DY, tbl.CD
		,ROW_NUMBER() OVER(PARTITION BY DY ORDER BY CASE WHEN CD='AA' THEN 1 WHEN CD='AC' THEN 2 WHEN CD='TD' THEN 3 END ) rn 
	FROM tbl 
	WHERE CD IN ('AA','AC','TD')
) AA 
WHERE RN = 1 

SELECT dy
     , MIN(cd) cd
  FROM t
 WHERE cd IN ('AA', 'AC', 'TD')
 GROUP BY dy
 ORDER BY dy
;