Greetings,



Can Suprtool give me the record with the greatest amount of a given item?



Let's say I have this dataset with these items...



NAME             X30

COST               Z4



I have two records for NAME = "TABLE" with different costs of 900 and 1000.

I have two records for NAME = "CHAIR" with different costs of 800 and 750.



I would like Suprtool to give me the records with...

NAME = TABLE & COST = 100

NAME = CHAIR & COST = 800



I'm thinking I can get all the data and sort by COST, output the data to a

file, then input the new file and extract with a DUPLICATE NONE KEYS

statement to get the first record of each item, which logically would be the

item with the greatest cost.



Any help will be appreciated.



Thanks,



Ernie

________________________________

This message, including any attachments, is intended solely for the use of the named recipient(s) and may contain confidential and/or privileged information. Any unauthorized review, use, disclosure or distribution of this communication(s) is expressly prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy any and all copies of the original message.

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *