{{htmlmetatags>
metatag-description=(중복 제거, DISTINCT, GROUP BY, 데이터베이스, DBMS, SQL, MySQL, MariaDB, MSSQL, Oracle, Tibero, PostgreSQL)
metatag-og:description=(중복 제거, DISTINCT, GROUP BY, 데이터베이스, DBMS, SQL, MySQL, MariaDB, MSSQL, Oracle, Tibero, PostgreSQL)
}}

====== 중복 제거 ======

<sxh sql; gutter: true;>
/*
	MySQL/MariaDB
	MSSQL
	Oracle
	PostgreSQL
*/
-- DISTINCT
SELECT
	DISTINCT {컬럼}
FROM
	{테이블}
;

-- GROUP BY
SELECT
	{컬럼}
	, COUNT(*)
FROM
	{테이블}
GROUP BY
	{컬럼}
;
</sxh>

{{tag>"쿼리" "Query" "기본"}}