Oracle DISTINCT

The Oracle DISTINCT statement uses to return only unique values.

Oracle DISTINCT example

Select Distinct 
user_id, name
From users_log;  

Select Distinct 
b.author, b.book_name
From books b 
Where b.author = 'SMITH'
And book_name Like '%ORACLE%'

Select 
avg(Distinct price)
From books  
Where book_name Like = '%JAVA%';