I am trying to select the smallest Directionality value based on a selection of two Workingspace values:
In the above picture, there are two "Jeffery's" selected, I want to then select the Jeffery with Directionality 2 (I.E. the smaller one) without using = 2. I know there is a max/ min SQL expression:
DIRECTIONALITY = (SELECT MIN( DIRECTIONALITY) FROM TableName)
But this returns no values when choosing the select from current selection method. HOWEVER, if I create a new selection, this SQL does return a selection of 1 (it selects the row where Directionality is 1).
Is there a way to tell ArcMap to select the smallest value of a previous selection based on a different field? Specifically in Model Builder.