Select by Attributes minimum value

Discussion created by ablakey on Oct 30, 2013
Latest reply on Oct 30, 2013 by csny490

I have a Feature Layer of points. From this feature layer, I want to select only one point: the one with the minimum Elevation.

In ArcGIS I got it working with:

"Elevation "= (SELECT MAX("Elevation") FROM allpoints)

Now I need to transpose this to Python. I'm trying to figure out something like this:

pointMinClause = '"Elevation "= (SELECT MIN("Elevation") FROM  ????
arcpy.SelectLayerByAttribute_management (inputLayer,'NEW_SELECTION',pointMinClause)

I'm not sure how to reference the data in the same way that I do it in ArcGIS Desktop.

I also may be doing the rest of that query improperly for arcpy; I'm not sure.