Help with DISTINCT in SELECT

[aeron glemann]

Hi- Someone here turned me onto the DISTINCT keyword which works beautifully. However, I can't seem to put together what I want to do from the docs - I'm hoping someone could help me with this:

I have a big table of Countries, Cities and Coordinates (Latitude and Longitude). I can easily use "SELECT DISTINCT country" to pull out the non-duplicating country names - however how can I also get the Coordinates that correspond to those rows? "SELECT DISTINCT country, coordinates" naturally returns almost all records. What syntax am I looking for?

Any help is greatly appreciated.