RE: SQL/Query query :)

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