Selecting max value in SQL query by group in ARCMAP

Question

HI, I am working with a feature class stored in a File Geodatabase In ArcGIS 10, . I want select the maximum value by ID like the example below:

I tried the following sql query but without result :  VALUE in (SELECT max(VALUE) FROM featureClass GROUP BY ID)

How can I solve?

Thanks.IDVALUE151211023242631632034

khalidechlouchi · Answer

Thank you DuncanHornby,  you are right, GROUP BY is not supported in geodatabases file and shape files, I think I will try to do it on personal geodatabase with ACCESS.

khalidechlouchi · Answer

Thank you for your feedback, the values are all numeric, I tried your solution, but it didn't work.

Hornbydd · Answer

I don't believe File GeoDatabases support GROUP BY when selecting rows in a table? A quick search of this forum and GIS SE and you see many threads about the issue.

If you want to create a table of just that data (which is different to selecting rows) then you can use the summary statistics tool as shown below: