Select by attribute query to select the maximum value entry

Question

Hi,

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;

Address_IDBA1A2A3B1B2

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.

HemantAngarkar2 · Answer

I tried without brackets and without quotes, still nothing. thanks for the reply!!

HemantAngarkar2 · Answer

Thanks Darren, I am on 10.2.1 where these queries don't work. It works in 9.3.1. GIS Stackexchange were not working on select by attribute. Thanks for the help.

XanderBakker · Answer

The field names are between square brackets as with a file geodatabase you don't use brackets nor quotes around the field names.