General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only