SELECT Field1,Field2,Field3,COUNT(*) FROM MyTable GROUP BY 2 ORDER BY 2 INTO CURSOR TEMPHowever, 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.