AnsweredAssumed Answered

how to use MAX function in Definition Query/ArcMap?

Question asked by wilsonl on Nov 9, 2018
Latest reply on Nov 9, 2018 by Dan_Patterson

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.

WL 

Attachments

Outcomes