>>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.
>
>I'm not sure if I understood this completely but.......
>
>I don't know how to do it in one query but
>
>
>SELECT Field1,Field2,Field3 FROM MyTable ORDER BY 1,2 INTO CURSOR hold NOFILTER
>SELECT Field1,Field2,Field3 FROM temp GROUP BY Field1 INTO CURSOR temp
>
David's answer was what I was looking for. Thanks