Selecting just one

[oracleguy]

Okay lets say I have a table organized like this:

Events
Event1
Event1
Event1
Event2
Event2
Event3
Event3
Event4

How can I query the database so that it only returns one of each?

So it would return:
Event1
Event2
Event3
Event4

[Spookster]

SELECT DISTINCT event FROM tablename;

[oracleguy]

Thanks :thumbsup: that did it.