topic Re: Select by attribute query to select the maximum value entry in Geoprocessing Questions

Select by attribute query to select the maximum value entry

HemantAngarkar2 — Thu, 20 Nov 2014 23:02:17 GMT

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_ID	B
A	1
A	2
A	3
B	1
B	2

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.

Re: Select by attribute query to select the maximum value entry

DarrenWiens2 — Thu, 20 Nov 2014 23:40:14 GMT

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.

Re: Select by attribute query to select the maximum value entry

XanderBakker — Thu, 20 Nov 2014 23:42:35 GMT

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

Re: Select by attribute query to select the maximum value entry

HemantAngarkar2 — Fri, 21 Nov 2014 21:43:37 GMT

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.

Re: Select by attribute query to select the maximum value entry

HemantAngarkar2 — Fri, 21 Nov 2014 21:45:18 GMT

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