WITH T (국가, 코드) AS ( SELECT '한국', 71 FROM DUAL UNION ALL SELECT '한국', 71 FROM DUAL UNION ALL SELECT '한국', 49 FROM DUAL UNION ALL SELECT '일본', 55 FROM DUAL UNION ALL SELECT '일본', 55 FROM DUAL UNION ALL SELECT '일본', 55 FROM DUAL UNION ALL SELECT '일본', 54 FROM DUAL UNION ALL SELECT '대만', 77 FROM DUAL UNION ALL SELECT '미국', 80 FROM DUAL ) SELECT 국가, 코드 FROM ( SELECT 국가, 코드, RANK() OVER(PARTITION BY 국가 ORDER BY COUNT(1) DESC) AS RNK FROM T GROUP BY 국가, 코드 ) WHERE RNK = 1