I have a SQL which is returning a set of records grouped. So, it goes like this:

SELECT Field1,Field2,Field3,COUNT(*) FROM MyTable GROUP BY 2 ORDER BY 2 INTO CURSOR TEMP

However, I would like to specify the order of the selected record within a group. So, for example, assuming I would have the first record to have a count of 3, which means I would have 3 records within that group, I would like to extract the record within that group which is ordered by Field2. By default, I believe it takes the last one it finds.