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.