Michel,

If you just needed ONE additional field with the lowest value, you could do this this:

SELECT MIN(Field1) AS somename, Field2, COUNT(*) FROM MyTable ;
GROUP BY 2 INTO CURSOR TEMP

If you need all the fields for that same record, I don't have an idea.