MS SQL。중복 제거(DISTINCT, GROUP BY)

# DISTINCT

 

SELECT DISTINCT [컬럼1], [컬럼2], ..., [컬럼n]
  FROM [테이블명]

 

 

# GROUP BY

 

SELECT [컬럼1], [컬럼2], ..., [컬럼n]
  FROM [테이블 명]
 GROUP BY [컬럼1], [컬럼2], ..., [컬럼n]
 
-- 중복 데이터 조회
SELECT [컬럼1], [컬럼2], ..., [컬럼n]
  FROM [테이블 명]
 GROUP BY [컬럼1], [컬럼2], ..., [컬럼n]
HAVING COUNT(*) > 1

 

<HAVING 조건 링크>

[Database/MS SQL] - MS SQL。HAVING