-- RANDOM 2개 SELECT id,name,code FROM ( SELECT AA.id, AA.name, AA.code , ROW_NUMBER () OVER (PARTITION BY AA.CODE ORDER BY DBMS_RANDOM.VALUE()) RN FROM 테이블A AA, 테이블B BB WHERE AA.CODE = BB.CODE ) WHERE RN <= 2 ; -- EDITDATE 최신순 2개 SELECT id,name,code FROM ( SELECT AA.id, AA.name, AA.code , ROW_NUMBER () OVER (PARTITION BY AA.CODE ORDER BY AA.EDITDATE DESC) RN FROM 테이블A AA, 테이블B BB WHERE AA.CODE = BB.CODE ) WHERE RN <= 2 ;