|
Hi, I have a PF containing data like this: Proc Itms ------ ---- 300005 18 300005 22 300005 27 300006 48 300020 7 300020 8 300020 11 I am trying to find a way to retrieve the record with the lowest value in the Itms field per Proc entry. Given the above example I would get this: 300005 18 300006 48 300020 7 I'm trying to do this with Query/400 or with STRQMQRY. Is it possible? Best regards, Matthias -- -------------------------------------------------- Matthias Oertli <oertlim@s054.aone.net.au>
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.