Essential SQL

Select distinct unique values only

suggest change 
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
Found a mistake? Have a question or improvement idea? Let me know.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:

Table Of Contents