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
Exercice interactif pratique
Essayez cet exercice en complétant cet exemple de code.
-- Select the composers from the track table
___ ___
___ ___