[Qgis-user] Selecting maximum values in drill holes

[Phil Wyatt]

How about the following as a virtual layer

Select max(depth to) from YOURLAYER - deepest 'depth to' for all drill holes

Or 

Select drill hole id, max(depth to ) from YOURLAYER group by drill hole id - deepest depth per hole id?


-----Original Message-----
From: Qgis-user <qgis-user-bounces at lists.osgeo.org> On Behalf Of Grant Boxer
Sent: Friday, 26 June 2020 12:20 PM
To: qgis-user at lists.osgeo.org
Subject: [Qgis-user] Selecting maximum values in drill holes

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