[SQL] 오라클 중복제거 DISTINCT, GROUP BY

중복 데이터 한개만 두고 나머지 제거하는 방법

1. DISTINCT절
2. GROUP BY 절

SELECT  DISTINCT
        ,A.*
FROM    TB_MEMBER A
WHERE   A.NAME = '김'

 

SELECT  A.*
FROM    TB_MEMBER A , EMP B
WHERE   1 = 1
GROUP BY A.NAME, B.NAME

 

 

---

 

참고링크

[Oracle] 중복 데이터 제거 DISTINCT , GROUP BY