× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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 thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.