AnsweredAssumed Answered

Select by attribute query to select the maximum value entry

Question asked by hemant6021 on Nov 20, 2014
Latest reply on Nov 21, 2014 by hemant6021

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_IDB
A1
A2
A3
B1
B2

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.

Outcomes