WITH T AS (
SELECT '73455' V FROM DUAL UNION ALL
SELECT '73455' FROM DUAL UNION ALL
SELECT '55666' FROM DUAL
)
-- ROW_NUMBER() OVER() 이용
SELECT V
FROM ( SELECT V , ROW_NUMBER() OVER(PARTITION BY V ORDER BY ROWNUM ) RN
FROM T
)
WHERE RN = 1
-- GROUP BY 이용
SELECT V
FROM T
GROUP BY V
by 많이부족합니다
[2018.04.30 10:58:35]
감사합니다. 많은 도움이 되었습니다.
by 마농
[2018.04.30 13:12:58]
SELECT value
FROM test
WHERE ROWNUM = 1
;
댓글등록
SQL문을 포맷에 맞게(깔끔하게) 등록하려면 code() 버튼을 클릭하여 작성 하시면 됩니다.