topic Re: select the 3 features that have the largest attribute value in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/select-the-3-features-that-have-the-largest/m-p/206235#M9120 <HTML><HEAD></HEAD><BODY><P>Thanks Katherine, I did see that. Just figured that since it seems like such an important query that ESRI would have a tool. Guess not.&nbsp;&nbsp;</P></BODY></HTML> Mon, 17 Aug 2020 20:46:39 GMT IanIrmischer 2020-08-17T20:46:39Z select the 3 features that have the largest attribute value https://community.esri.com/t5/arcgis-pro-questions/select-the-3-features-that-have-the-largest/m-p/206232#M9117 <HTML><HEAD></HEAD><BODY><P>I need to select the 3 features that have the largest attribute value. How is this best completed? I would like to do this within a model builder environment. I have been trying to figure out the sql statement within the select tool but am having syntax problems.</P></BODY></HTML> Mon, 17 Aug 2020 13:12:02 GMT https://community.esri.com/t5/arcgis-pro-questions/select-the-3-features-that-have-the-largest/m-p/206232#M9117 IanIrmischer 2020-08-17T13:12:02Z Re: select the 3 features that have the largest attribute value https://community.esri.com/t5/arcgis-pro-questions/select-the-3-features-that-have-the-largest/m-p/206233#M9118 <HTML><HEAD></HEAD><BODY><P>Have you seen this post? Might be helpful...</P><P><A class="link-titled" href="https://gis.stackexchange.com/questions/89348/using-select-layer-by-attribute-to-return-top-3-records" title="https://gis.stackexchange.com/questions/89348/using-select-layer-by-attribute-to-return-top-3-records">arcgis desktop - Using Select Layer By Attribute to return top 3 records - Geographic Information Systems Stack Exchange</A>&nbsp;</P><P></P><P>As the post states, "Python scripts in the form of custom tools can be used in Model Builder".&nbsp;</P><P></P><P>Hope that helps at least a bit! Good luck!</P></BODY></HTML> Mon, 17 Aug 2020 13:23:38 GMT https://community.esri.com/t5/arcgis-pro-questions/select-the-3-features-that-have-the-largest/m-p/206233#M9118 Katie_Clark 2020-08-17T13:23:38Z Re: select the 3 features that have the largest attribute value https://community.esri.com/t5/arcgis-pro-questions/select-the-3-features-that-have-the-largest/m-p/206234#M9119 <HTML><HEAD></HEAD><BODY><P>This is yet another example of where Esri has done a poor job of implementing SQL support in the file geodatabase.&nbsp; If your data were stored in just about any other database, the query would be quite trivial, but doing something simple like this is way more complicated than it needs to be because Esri doesn't support TOP, LIMIT, or similar keywords.</P></BODY></HTML> Mon, 17 Aug 2020 20:25:36 GMT https://community.esri.com/t5/arcgis-pro-questions/select-the-3-features-that-have-the-largest/m-p/206234#M9119 JoshuaBixby 2020-08-17T20:25:36Z Re: select the 3 features that have the largest attribute value https://community.esri.com/t5/arcgis-pro-questions/select-the-3-features-that-have-the-largest/m-p/206235#M9120 <HTML><HEAD></HEAD><BODY><P>Thanks Katherine, I did see that. Just figured that since it seems like such an important query that ESRI would have a tool. Guess not.&nbsp;&nbsp;</P></BODY></HTML> Mon, 17 Aug 2020 20:46:39 GMT https://community.esri.com/t5/arcgis-pro-questions/select-the-3-features-that-have-the-largest/m-p/206235#M9120 IanIrmischer 2020-08-17T20:46:39Z Re: select the 3 features that have the largest attribute value https://community.esri.com/t5/arcgis-pro-questions/select-the-3-features-that-have-the-largest/m-p/1380394#M78545 <P>See&nbsp;<A href="https://community.esri.com/t5/arcgis-pro-ideas/use-select-by-attributes-to-select-greatest-n/idi-p/1370912" target="_blank">https://community.esri.com/t5/arcgis-pro-ideas/use-select-by-attributes-to-select-greatest-n/idi-p/1370912</A>&nbsp;</P> Fri, 09 Feb 2024 15:57:07 GMT https://community.esri.com/t5/arcgis-pro-questions/select-the-3-features-that-have-the-largest/m-p/1380394#M78545 KoryKramer 2024-02-09T15:57:07Z Re: select the 3 features that have the largest attribute value https://community.esri.com/t5/arcgis-pro-questions/select-the-3-features-that-have-the-largest/m-p/1380518#M78562 <P><A href="https://community.esri.com/t5/arcgis-pro-questions/arcgis-3-0-2-what-tool-can-select-the-records-with/m-p/1370137/highlight/true#M77404" target="_self">What tool can select the records with the highest values in a particular field?</A></P> Fri, 09 Feb 2024 18:12:58 GMT https://community.esri.com/t5/arcgis-pro-questions/select-the-3-features-that-have-the-largest/m-p/1380518#M78562 Bud 2024-02-09T18:12:58Z