Using SELECT with DISTINCT

The DISTINCT keyword can be used to retrieve unique rows only from the results of a query. The following example retrieves all the unique titles from the Customers table.

SELECT DISTINCT ContactTitle FROM Customers