SQL SELECT DISTINCT

List all French customer cities (without duplicates).

SELECT DISTINCT City
  FROM Customer
 WHERE Country = 'France'

DISTINCT syntax.

SELECT DISTINCT column-name
  FROM table-name

DISTINCT syntax with COUNT or other aggregates.

SELECT COUNT (DISTINCT column-name)
  FROM table-name

SELECT DISTINCT Country
  FROM Supplier
ORDER BY COUNTRY

Country
Australia
Brazil
Canada
Denmark

SELECT COUNT (DISTINCT Country) AS Number
  FROM Supplier

• Our Sql SELECT Tutorial
• Our Sql SELECT TOP Tutorial
• Our Sql Aggregate Functions Reference