I have a database of water wells where some wells have the same location however, some have unique locations. At each point (unique or not) I need to select the minimum value. In my case, it is "static water level". Ultimately, I want to interpolate these values. I am trying query builder without success.
You should be able to do this with the Summary Statistics tool available in the Analysis Tools > Statistics toolset. Select the static water level field as Statistic Field and Min as Statistics type, and as case field(s) a field or combination of fields that uniquely define each location (E.g. X/Y field, locationid - do not use shape for the case field) .