SELECT DISTINCT
Often query results will include many duplicate values. You can use the DISTINCT
keyword to select the unique values from a field.
This might be useful if, for example, you're interested in knowing which languages are represented in the films
table. See if you can find out what countries are represented in this table with the following exercises.
This exercise is part of the course
Intermediate SQL
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Return the unique countries from the films table
___