Need SQL Help - Select Max Value by Type Field

DawnLasprugato — Mon, 12 Apr 2010 22:46:50 GMT

I think I can best describe my problem with a dummy example:

Let's say I have a City point shapefile of all the cities in the US.
The City point shapefile has three attributes: city_name, state_name, and population.

How do I select the highest population city for each state? In the end, I'll have one point selected for each state representing the highest population city for that state.

I am hoping to do this using a SQL script.
Gosh, this sounds so GIS101, but I really need some help 😮

Need SQL Help - Select Max Value by Type Field

AlanToms — Tue, 13 Apr 2010 11:18:35 GMT

I would run the Summary Statisitcs tool, grouped by state to give me the city with the highest population. From there join the table back to your feature class or run a query with the city names.

Alan

topic Need SQL Help - Select Max Value by Type Field in Geoprocessing Questions

Need SQL Help - Select Max Value by Type Field

Need SQL Help - Select Max Value by Type Field