/* MySQL/MariaDB MSSQL Oracle PostgreSQL */ -- DISTINCT SELECT DISTINCT {컬럼} FROM {테이블} ; -- GROUP BY SELECT {컬럼} , COUNT(*) FROM {테이블} GROUP BY {컬럼} ;