ORDER BY not necessary? Perhaps you are right, but I am not sure. I may be wrong, but I think I read somewhere that there is no guarantee that the records will appear in any specific order. In other words, it might work in some cases, and not in others.


On VFP9 perhaps, the order can not will be guarantee (but I think not).

The reason? Simple, VFP does not optimize GROUP BY and ORDER BY,
and therefore it executes GROUP BY with a simple algorithm
(in truth not much efficient < 50%),
and this necessarily orders the columns in ASCENDING ORDER.

I think that nobody can find against example.

Fabio