topic Re: Max value from two columns in ArcGIS table query? in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/max-value-from-two-columns-in-arcgis-table-query/m-p/264616#M9095 <HTML><HEAD></HEAD><BODY><P>Just use <STRONG>Summary Statistics</STRONG> tool.</P><P>make ObjectID as statistics field, and statistics type is <STRONG>MAX,</STRONG></P><P>and <SPAN style="text-decoration: underline;">case field</SPAN> is <STRONG>arcid</STRONG>. as the following picture.</P><P></P><P><IMG alt="" class="image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/363943_Untitled.jpg" style="width: 620px; height: 414px;" /></P></BODY></HTML> Sat, 22 Jul 2017 10:23:39 GMT AbdullahAnter 2017-07-22T10:23:39Z Max value from two columns in ArcGIS table query? https://community.esri.com/t5/geoprocessing-questions/max-value-from-two-columns-in-arcgis-table-query/m-p/264615#M9094 <HTML><HEAD></HEAD><BODY><P>Hi,&nbsp;<SPAN style="background-color: #ffffff;">I'm looking for a tool that will&nbsp;select just these certain features (mark them in a new column or just delete all other features).&nbsp;</SPAN><SPAN style="background-color: #ffffff;">It´s the highest number of "OBJECTID" for every number of "arcid".</SPAN></P><P><SPAN style="background-color: #ffffff;">Thanks a lot,&nbsp;</SPAN><SPAN style="background-color: #ffffff;">Jan</SPAN></P><P></P><P><SPAN style="background-color: #ffffff;"><IMG alt="" class="image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/363896_query.PNG" style="height: auto;" /></SPAN></P></BODY></HTML> Fri, 21 Jul 2017 20:28:56 GMT https://community.esri.com/t5/geoprocessing-questions/max-value-from-two-columns-in-arcgis-table-query/m-p/264615#M9094 JanTichy 2017-07-21T20:28:56Z Re: Max value from two columns in ArcGIS table query? https://community.esri.com/t5/geoprocessing-questions/max-value-from-two-columns-in-arcgis-table-query/m-p/264616#M9095 <HTML><HEAD></HEAD><BODY><P>Just use <STRONG>Summary Statistics</STRONG> tool.</P><P>make ObjectID as statistics field, and statistics type is <STRONG>MAX,</STRONG></P><P>and <SPAN style="text-decoration: underline;">case field</SPAN> is <STRONG>arcid</STRONG>. as the following picture.</P><P></P><P><IMG alt="" class="image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/363943_Untitled.jpg" style="width: 620px; height: 414px;" /></P></BODY></HTML> Sat, 22 Jul 2017 10:23:39 GMT https://community.esri.com/t5/geoprocessing-questions/max-value-from-two-columns-in-arcgis-table-query/m-p/264616#M9095 AbdullahAnter 2017-07-22T10:23:39Z