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?
Just to confirm, your values in the above table are left-indented, suggesting text. Are your values text or numeric values. Numeric values usually displayed w/ right-indent.
Regarding your sql, maybe change your sql from:
VALUE in (SELECT max(VALUE) FROM featureClass GROUP BY ID)
[Value] IN (SELECT MAX( [Value] ) FROM featureClass GROUP BY [ID] ).
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: