how to SELECT but no Dupes also logical question

[loren646]

got three columns

 

Table: Rentals:

Columns: house number, street, owner. 

 

what's the coding? 

 

"SELECT owner FROM Rentals" 

 

Not sure what to write so i don't select duplicate owners. 

 

or is it better to select all and then when echo don't echo the duplicates? 

Edited April 4, 2013 by loren646

[Barand]

SELECT DISTINCT owner FROM rentals

[loren646]

thanks Sen 

[Barand]

You're welcome, Advanced

[Jessica]

I think we need to change the position of our usernames. Because amazingly numerous people can't figure out that everyone else's name is in the same spot as their own username.

Edited April 4, 2013 by Jessica

[Barand]

I wholeheartedly agree with you, Dallas