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"
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
No comments:
Post a Comment