Re: Help with DISTINCT in SELECT

[Felix Geerinckx]

aeron glemann wrote:

> 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?

It's not clear to me what coordinates you want. You imply there are many records of the same country, each with its own set of coordinates. Which one of these do you want?

--
felix