Get startedGet started for free

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

View Course

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

-- Return the unique countries from the films table
___
Edit and Run Code