Is there a way to do an SQL query for the lowest value?

Question

I am trying to build a model that will first select a group of points based on an ID field and then select the lowest value in a distance field so I will get the shortest distance for each group.  Is there a way to build a query for that?
Thanks!
Rebecca

RichardFairhurst · Answer

Thanks - that worked great!

Please mark the thread answered for the benefit of others looking for solutions to similar problems.  I assume you used the SummaryStatistics approach given the speed of your respoinse.  Thanks.

RebeccaNoll · Answer

Thanks - that worked great!

RichardFairhurst · Answer

I am trying to build a model that will first select a group of points based on an ID field and then select the lowest value in a distance field so I will get the shortest distance for each group.  Is there a way to build a query for that?
Thanks!
Rebecca

No, not within a single table/feature class.  There is a way to do it if there are two tables/feature classes.  See the discussion on Subqueries here.  I normally use the SummaryStatistics tool in the Analysis group to get a Min value and join it to the ID to select the lowest record or make other adjustments relative to the minimum value.