SELECT DISTINCT ContinentCode FROM Countries;
该查询将返回表中列的所有DISTINCT(唯一,不同)值ContinentCodeCountries
SQLFiddle演示