AnsweredAssumed Answered

Help with SQL expression

Question asked by drewlindow on Jan 27, 2014
Latest reply on Jan 28, 2014 by rfairhur24
I have a dataset of end points of some stream lines. I want to select the points that are lowest in elevation out of each set of endpoints.

The attributes of the point dataset include "elevation" of each point and a number "stream" representing the stream it came from. So I'm looking for something like: select the point with minimum "elevation" from each pair of points that have the same "stream" value

Outcomes