Hardcode/SQL

[SQL] 중복제거 SELECT DISTINCT

SELECT DISTINCT 중복제거 SELECT DISTINCT 컬럼명 FROM 테이블명; SELECT COUNT (DISTINCT 컬럼명) FROM 테이블명; Example SELECT DISTINCT Country FROM Customers; SELECT COUNT(DISTINCT Country) FROM Customers;