get one record per duplicate field 1

[sammye]

I’m having trouble retrieving just the 1st record where there are two available. Here’s an example table:

My table:
Name Address
---- -------
Bob 1st street
Bob 4th ave
Ann 3rd street
Ann 7th ave

What I’d like to retrieve:
Name Address
---- -------
Bob 1st street
Ann 3rd street

I don’t really care which record for Bob and Ann I retrieve, but I just want one for each. Any guesses? Thanks.

 

[jrbarnett]

select name, min (address) As Address
from table
group by name

John

 

[sammye]

john, thanks for the help. exactly what I was looking for.