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 <[email protected]> On Behalf Of Grant Boxer Sent: Friday, 26 June 2020 12:20 PM To: [email protected] 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 [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user _______________________________________________ Qgis-user mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
