|
Use a query with sort/break on Proc field, on report summary functions, use 3(minimum) on Itms field, output to a file, summary only. Run qry on file created above to list Mark Allen I.S. Manager Wilkes Telephone & Electric A Dycom Company Phone: (706) 678-9565 Email: allenmark@nu-z.net http://www.nu-z.net :-----Original Message----- :From: midrange-l-admin@midrange.com :[mailto:midrange-l-admin@midrange.com] On Behalf Of Matthias Oertli :Sent: Thursday, February 14, 2002 2:41 AM :To: midrange-l@midrange.com :Subject: SQL/Query query :) : : :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> :_______________________________________________ :This is the Midrange Systems Technical Discussion (MIDRANGE-L) :mailing list To post a message email: MIDRANGE-L@midrange.com :To subscribe, unsubscribe, or change list options, :visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l :or email: MIDRANGE-L-request@midrange.com :Before posting, please take a moment to review the archives :at http://archive.midrange.com/midrange-l. : :
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.