DISTINCT

1 개요

SQL SELECT DISTINCT Statement

DISTINCT로 중복된 행 제거

sql

Copy

SELECT DISTINCT Country FROM Customers;

sql

Copy

SELECT DISTINCT ProductID FROM Production.ProductInventory ;

2 같이 보기

• DISTINCT 값들을 INSERT 하기
• GROUP BY
• SELECT

3 참고

• https://www.w3schools.com/sql/sql_distinct.asp
• https://technet.microsoft.com/ko-kr/library/ms187831(v=sql.105).aspx
• https://www.scaler.com/topics/distinct-in-sql/