10 | 김씨 | ₩30,000 |
10 | 이씨 | ₩50,000 |
10 | 박씨 | ₩100,000 |
20 | 김씨 | ₩30,000 |
20 | 박씨 | ₩100,000 |
30 | 김씨 | ₩200,000 |
30 | 이씨 | ₩10,000 |
30 | 박씨 | ₩20,000 |
10 | 김씨 | ₩30,000 |
이씨 | ₩50,000 | |
박씨 | ₩100,000 | |
20 | 김씨 | ₩30,000 |
박씨 | ₩100,000 | |
30 | 김씨 | ₩200,000 |
이씨 | ₩10,000 | |
박씨 | ₩20,000 |
WITH T (V1,V2,V3) AS ( SELECT '10','김씨','₩30,000' FROM DUAL UNION ALL SELECT '10','이씨','₩50,000' FROM DUAL UNION ALL SELECT '10','박씨','₩100,000' FROM DUAL UNION ALL SELECT '20','김씨','₩30,000' FROM DUAL UNION ALL SELECT '20','박씨','₩100,000' FROM DUAL UNION ALL SELECT '30','김씨','₩200,000' FROM DUAL UNION ALL SELECT '30','이씨','₩10,000' FROM DUAL UNION ALL SELECT '30','박씨','₩20,000' FROM DUAL ) SELECT DECODE(rn , 1 , v1) , v2 , v3 FROM (SELECT T.* , ROW_NUMBER() OVER(PARTITION BY V1 ORDER BY ROWNUM ) rn FROM T )