Hi Guys,
I'm querying a zip code database to find where records match a city name.
For instance, if I query the database for 'Saint Louis' I will get a bunch of matches for St. Louis, MO (one for every zip code), and a few matches for smaller towns in other states, that just happen to also be named Saint Louis.
SELECT city, state, zipcode
FROM zipcodes
WHERE city = 'saint louis'
I need to find which set of results has the most zip code matches for a particular state.
So with the above query, I'd get about 71 records returned, with all but 3 being from the Saint Louis in Missouri.
How could I figure out which CityName has the zip code most matches for a state? I'm trying to figure which city has the most zips.
I'm querying a zip code database to find where records match a city name.
For instance, if I query the database for 'Saint Louis' I will get a bunch of matches for St. Louis, MO (one for every zip code), and a few matches for smaller towns in other states, that just happen to also be named Saint Louis.
SELECT city, state, zipcode
FROM zipcodes
WHERE city = 'saint louis'
I need to find which set of results has the most zip code matches for a particular state.
So with the above query, I'd get about 71 records returned, with all but 3 being from the Saint Louis in Missouri.
How could I figure out which CityName has the zip code most matches for a state? I'm trying to figure which city has the most zips.