In ARCGIS 10 I am trying to do a Definition Query that will select the records that are the max values from a specific group.
Here is what I have tried in the Query Builder but I am getting an "the SQL statement is invalid." error.
"TL" IN (SELECT max( "TL" ) FROM "Instrument_Locations2_20120227" GROUP BY "Site_ID" )
Any ideas would be appreciated!