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

Discussion created by rivkanemir on Jan 9, 2012
Latest reply on Jan 9, 2012 by rfairhur24
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?