Stop Printing double values SQL

Hello Guys!

Oracle SQL

I am trying to find a way to stop my sql Query print duplicate values.

For example Results coming for a table are:

Nikos
Nikos
Nikos
Tony
Tony

The result I want:

Nikos
Tony

Thanks in advance!

Answer

Use DISTINCT to remove duplicate values :

SELECT DISTINCT col
FROM table t;