[Qgis-user] Selecting maximum values in drill holes

[Matt Boyd]

Hi Grant,
how are you selecting and how is your data stored?
If the drill hole values are in some sort of sql database then you could
ORDER BY "value" descending then SELECT DISTINCT drillhole to get a unique
value for each drillhole.
My SQL is rusty and this is pretty vague.

Matt

On Fri, Jun 26, 2020 at 12:19 PM Grant Boxer <boxerg at iinet.net.au> wrote:

> I am trying to find out the best way to select the highest values in a
> set of drill holes as well as the bottom of hole values. The files
> contain drill hole id, depth from, depth to and assay values. If have
> tried the maximum function but I don't think I have the syntax correct.
> Anyone have any suggestions?
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200626/75a5a703/attachment.html>