WITH t AS ( SELECT '홍길동' dirver_nm FROM dual UNION ALL SELECT '홍길동' dirver_nm FROM dual UNION ALL SELECT '이순신' dirver_nm FROM dual UNION ALL SELECT '이순신' dirver_nm FROM dual UNION ALL SELECT '이순신' dirver_nm FROM dual ) select dirver_nm from ( select dirver_nm , row_number() over(partition by dirver_nm ORDER BY dirver_nm) AS rn from t ) where rn = decode(dirver_nm,'홍길동',1,rn ) ORDER BY 1