Message-ID: <00f301be35fe$23155b00$61246ccf@timnt.desm.uswest.net>
Reply-To: "Tim Perdue, The Des Moines City.net" <tim@dmcity.net>
From: "Tim Perdue, The Des Moines City.net" <tim@dmcity.net>
To: "Peter Garner" <peter_garner@yahoo.com>, <pgsql-sql@hub.org>
Subject: Re: [SQL] SELECT DISTINCT
Date: Fri, 1 Jan 1999 21:15:23 -0600
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Thanks - the MIN and GROUP BY did the trick. Here's what I did in the end:

select fld_city, min (fld_zip) from tbl_zip_city  where fld_state = 'IA'
group by fld_city;

And now I'm good to go!

Tim
The Des Moines City.net
http://desmoinesnet.com/


-----Original Message-----
From: Peter Garner <peter_garner@yahoo.com>
To: pgsql-sql@hub.org <pgsql-sql@hub.org>
Date: Friday, January 01, 1999 8:46 PM
Subject: Re: [SQL] SELECT DISTINCT


>Hi Tim,
>
>> select distinct fld_city, fld_zip from tbl_zip_city where
>fld_state='IA' and
>> fld_country='us';
>>
>> That query does not return distinct cities any more. It returns all
>cities
>> (because each city can have several zip codes).
>>
>
>Yes, that is what it is supposed to do, heheheh.  Try something like :
>
>select city, min (zip_code)
>from tbl_zip_city
>group by city
>having fld_state = 'IA'
>
>Basically since you have multiple zip codes and want only one per city
>you have to tell the sql engine which zip code to pick.  It won't just
>select one at random.  I hope this helps! :-)
>==
>
>Peace,
>
>Peter
>
>_________________________________________________________
>DO YOU YAHOO!?
>Get your free @yahoo.com address at http://mail.yahoo.com
>