query were names aren't the same

[grudz]

Hi,

I have a DB with a name column. Sometimes, the names might duplicated, so i was wondering how to write a query that says, show me 1 of the records instead of both...?

Thanx

[Velox Letum]

SELECT DISTINCT name FROM table

or...

SELECT name FROM table LIMIT 1