WITH t AS ( SELECT 1 id, '사과' a, '한국' b UNION ALL SELECT 2, '사과', '한국' UNION ALL SELECT 3, '사과', '한국' UNION ALL SELECT 4, '배' , '한국' UNION ALL SELECT 5, '멜론', '한국' ) SELECT CASE rn WHEN 1 THEN a END a , CASE rn WHEN 1 THEN b END b FROM (SELECT ROW_NUMBER() OVER(PARTITION BY a, b ORDER BY id) rn , a, b FROM t ) a ;