How to select the largest value grouped by another field in ArcPro?

[hansgreg]

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:

DBH = (SELECT max( "DBH" ) FROM "TI_MASTER" GROUP BY "COMMON_NAME" )

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?

TIA!

[MicZatorsky_AEC]

Do you need to use SQL?  If you can run a tool Summary Statistics will return a table:

• the stats field set to tree size, max
• the case field set to the common name