topic Re: how to use MAX function in Definition Query/ArcMap? in Geodatabase Questions

how to use MAX function in Definition Query/ArcMap?

WilsonLee — Fri, 09 Nov 2018 20:49:33 GMT

Hi All,

How I can select a record in a column with Largest/MAX value in "Definition Query" in ArcMap?

for example, i have a feature with 10 records

in the ID column; the records are 1, 2, 3,4,5,6,7,8,9,10

in the "Definition Query", i would like to select on the largest ID record

i have tried all kinds of MAX sql but they didn't work, any ideas?

ID >= MAX(ID)

"ID" >= MAX("ID") ....etc

thanks.

Re: how to use MAX function in Definition Query/ArcMap?

JoshuaBixby — Fri, 09 Nov 2018 21:55:52 GMT

The syntax would be

ID = (SELECT MAX(ID) FROM table)‍

Just a note of caution, using subqueries in definition queries isn't ideal. Depending on the complexity of the data set and the subquery itself, there can be performance or portability issues.

Re: how to use MAX function in Definition Query/ArcMap?

DanPatterson_Retired — Fri, 09 Nov 2018 21:59:25 GMT

This query selects the record with the maximum value... the 'select … from … ' syntax

buried a bit in ...

SQL reference for query expressions used in ArcGIS—ArcGIS Pro | ArcGIS Desktop

Re: how to use MAX function in Definition Query/ArcMap?

HeathAnderson — Tue, 21 Jul 2020 20:03:55 GMT

I am have a problem with the syntax Hopefully someone can assist. When i type in the sql expression Pro 2.5 finds an error but i can't seem to find what the errors is. I even copied the script directly from the blog and only changed out the fields and table, but still no luck

SQL reference for query expressions used in ArcGIS—ArcGIS Pro | Documentation

GDP2006 > (SELECT MAX(GDP2005) FROM countries)

Not sure if or why but the query is on a stand alone table

Re: how to use MAX function in Definition Query/ArcMap?

CraigSwadner — Tue, 21 Jul 2020 20:14:51 GMT

Check the database / schema , and permissions to table / layer

(SELECT MAX(GDP2005) FROM gisdata.dbo.countries)

Craig Swadner (GIS Coordinator)

City of Cape Coral

1015 Cultural Park Blvd.

Cape Coral, Fl 33990

Did you know the best way to report issues to ITS is to use the Service Desk system? This will ensure someone in ITS gets your request and allows us to track the progress. Please enter all your issues and/or questions by clicking https://breeze.cape.capecoral.net