https://community.esri.com/t5/arcgis-pro-questions/how-to-select-the-largest-value-grouped-by-another/m-p/1310738#M71322 <P>Do you need to use SQL?&nbsp; If you can run a tool <A href="https://pro.arcgis.com/en/pro-app/latest/tool-reference/analysis/summary-statistics.htm" target="_self">Summary Statistics</A>&nbsp;will return a table:</P><UL><LI>the stats field set to tree size, max</LI><LI>the case field set to the common name</LI></UL> Fri, 21 Jul 2023 23:17:18 GMT MicZatorsky_AEC 2023-07-21T23:17:18Z https://community.esri.com/t5/arcgis-pro-questions/how-to-select-the-largest-value-grouped-by-another/m-p/1283466#M68492 <DIV class=""><P>I'm working with tree inventory data and am trying to select the largest individual tree per species type. This is my python code that I'm inputting into ArcPro:</P><P>DBH = (SELECT max( "DBH" ) FROM "TI_MASTER" GROUP BY "COMMON_NAME" )</P><P>Where DBH is my tree size field, TI_MASTER is the attribute table, and COMMON_NAME is the species type field. I keep getting invalid syntax errors. Any suggestions?</P><P>TIA!</P></DIV> Thu, 27 Apr 2023 17:06:13 GMT https://community.esri.com/t5/arcgis-pro-questions/how-to-select-the-largest-value-grouped-by-another/m-p/1283466#M68492 hansgreg 2023-04-27T17:06:13Z https://community.esri.com/t5/arcgis-pro-questions/how-to-select-the-largest-value-grouped-by-another/m-p/1310738#M71322 <P>Do you need to use SQL?&nbsp; If you can run a tool <A href="https://pro.arcgis.com/en/pro-app/latest/tool-reference/analysis/summary-statistics.htm" target="_self">Summary Statistics</A>&nbsp;will return a table:</P><UL><LI>the stats field set to tree size, max</LI><LI>the case field set to the common name</LI></UL> Fri, 21 Jul 2023 23:17:18 GMT https://community.esri.com/t5/arcgis-pro-questions/how-to-select-the-largest-value-grouped-by-another/m-p/1310738#M71322 MicZatorsky_AEC 2023-07-21T23:17:18Z