Select distinct unique values only

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|