DISTINCT

DISTINCT In Oracle

DISTINCT will retrieve the first value of each group in multiple groups containing duplicates. DISTINCT can operate on a single or multiple columns.

SELECT DISTINCT COUNTRY FROM ARTIST;