R: SQL/Query query :)

Yes, it is:
*a*  Select Proc, min(Itms) from YourFile group by Proc  if Itms values are
unique,
*b*  Select Proc, min(Itms), count(*) from YourFile group by Proc, 2  if
Itms values are NOT unique

Sincerely
Domenico Finucci
Fiditalia , Milano, 02- 4301-2494


-----Messaggio originale-----
Da: Matthias Oertli [mailto:oertlim@s054.aone.net.au]
Inviato: giovedì 14 febbraio 2002 08.41
A: midrange-l@midrange.com
Oggetto: 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.