CommencerCommencer gratuitement

Removing duplicates

Let's dig a little bit deeper into the database. You want to find out which composers have written a song that is sold by eSymphony.

Since composers can write multiple songs, your results will probably include many duplicate values. If you want to select all unique values from a column, you can use the DISTINCT keyword.

Cet exercice fait partie du cours

Introduction to Oracle SQL

Afficher le cours

Exercice interactif pratique

Essayez cet exercice en complétant cet exemple de code.

-- Select the composers from the track table
___ ___
___ ___
Modifier et exécuter le code