ArcGIS 10.1 – Using SQL on Definition Query to Select Minimum Value

arcgis-10.1arcgis-desktopdefinition-query

In ArcGIS 10.1 I am trying to do a Definition Query that will select the records that are the min values from a table.

I try a lot of type of query like and it still not working.
Name table is Polygone_Buffer_Output
Attribute : Air_Mil

"Air_Mil" = (SELECT MIN( "Air_Mil" ) FROM "Polygone_Buffer_Output"

[Air_Mil] = (SELECT MIN( [Air_Mil] ) FROM "Polygone_Buffer_Output"

[Air_Mil] = (SELECT MIN( [Air_Mil] ) FROM [Polygone_Buffer_Output]

"Air_Mil" in (SELECT MIN( "Air_Mil" ) FROM "Polygone_Buffer_Output"

Best Answer

"Air_Mil" in (SELECT MIN( "Air_Mil" ) FROM Polygone_Buffer_Output

or

[Air_Mil] in (SELECT MIN( [Air_Mil] ) FROM Polygone_Buffer_Output

using square brackets or quotes depends on your underlying database implementation.

http://resources.arcgis.com/en/help/main/10.1/index.html#//00s500000033000000

Related Question