SQL Select distinct (unique values only)


Example

SELECT DISTINCT ContinentCode
FROM Countries;

This query will return all DISTINCT (unique, different) values from ContinentCode column from Countries table

ContinentCode
OC
EU
AS
NA
AF

SQLFiddle Demo