SQL SELECT DISTINCT Statement

The SQL SELECT DISTINCT Statement

The SELECT DISTINCT

statement is used to return only distinct
(unique) values.

In a table, a column may contain several duplicate values - and sometimes you want to list only the unique values.

Example

SELECT DISTINCT Country FROM Customers;

SELECT DISTINCT Syntax

Select Distinct

From

;

Demo Database

Below is a selection from the

CustomerID

CustomerName

ContactName

Address

City

PostalCode

Country

Alfreds Futterkiste

Maria Anders

Berlin

Germany

Ana Trujillo Emparedados y helados

Ana Trujillo

Mexico

Antonio Moreno

Mataderos 2312