I am trying to select by attribute query in a file geodatabase,
[Address_ID] In (SELECT [Address_ID] FROM [Sunset_and_Goldengate_Monday_II] GROUP BY [Address_ID] HAVING Count(*)>1 )
It is not working, whereas it works in Personal geodatabase. I want o select features which has maximum values in let's say b field. And I have Address_ID field which has duplicate entries like this;
So I want to select A which has 3 (Maximum) as a value in B field, also b which has 2 (maximum) as a value.
Any help is appreciated.
A quick search yielded this Knowledge Base Article (Select minimum and maximum values in the Select By Attributes dialog box) explaining that this cannot be done in File GDBs and these solutions, which are probably more complicated than you want to see, on GIS StackExchange.